Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by Trishka88

  1. Trishka88

    VBA: Attachment Send

    Thanks!
  2. Trishka88

    VBA: Attachment Send

    Dear Tek-Tips, I have a "pivot table" with course names (column A) and number of attendees(column B). Column A Column B Column C Course Title Number of ttendee(s) Course Owner course A 5 Rey course B 4 Walter Course C...
  3. Trishka88

    VBA: MS Word - Forms

    Ok I'll try that
  4. Trishka88

    VBA: MS Word - Forms

    Yes, that's the error message of the sample, how do I get it work please? Thanks
  5. Trishka88

    VBA: MS Word - Forms

    Here's the working file, I need to apply the MS Word VBA. Thankshttp://www.filedropper.com/workingfile
  6. Trishka88

    VBA: MS Word - Forms

    Hi, I have this file (see attached sample). It has text fields: Mr/Ms Name Date Business Clauses I would want to enter these via the userform, which loads when the word file opens. Data entered in the form will populate in the Word file. Among the fields in the example are: Text boxes...
  7. Trishka88

    worksheet_change event

    correct text is "change cost" entered in the message box for example. If it's not correct it will run the checkbox = true and if correct will run checkbox = true if not, it will run from columns("I").Hidden=False
  8. Trishka88

    worksheet_change event

    It works, thank you. I need to put control in my check box, currently this displays "hello", can it be possible to display a message box with a text box, then if the right text is entered, it will proceed to the next line: Private Sub CheckBox1_Click() 'If checkbox is selected, it runs TRUE...
  9. Trishka88

    worksheet_change event

    I placed it in the code, but get line 400 error after I change the option buttons (please see file). I'm looking if I could integrate the code below in the existing code in the attached file Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) ' Local Variables Dim...
  10. Trishka88

    worksheet_change event

    How do I do this via VBA, I tried (please see recent code inserted above where I inserted the Range("H28:I42").Select Selection.Locked = True Selection.FormulaHidden = False ActiveSheet.Protect Password:="rg", DrawingObjects:=False, Contents:=True, Scenarios:=False but I seem...
  11. Trishka88

    worksheet_change event

    But if the users accidentally enter data in the adjusted cost column, that's the reason why I want to lock it. To be sure they only enter data in the cells where they could enter data only. It seems that if there are computations in a cell or is part of a computation, if you had them locked...
  12. Trishka88

    worksheet_change event

    because, there will columns for the users and they can't change the entries in the cost and adjusted cost columns. I want that they could only change that part of the cell, however when I placed it in-between the codes I got the line 400 error
  13. Trishka88

    worksheet_change event

    How do I insert that in the procedure? I tried inserting the "protect" procedure after the 'end-if' then the unprotect after the "if-then". Note that users can change only our entry plus/minus columns, while when I unprotect I could change the cost columns which feeds to the adjusted columns...
  14. Trishka88

    worksheet_change event

    I tried using first via the protect sheet command in worksheet, then tried VBA: Range("H28:I42").Select Selection.Locked = True Selection.FormulaHidden = False ActiveSheet.Protect Password:="rg", DrawingObjects:=False, Contents:=True, Scenarios:= _ False...
  15. Trishka88

    worksheet_change event

    How do I protect the cells, I can't seem to protect the cells for the cost and original cost columns (H and I), I'm getting the "line 400 error". If I protected the spreadsheet, it wouldn't allow the plus/minus entry changes to appear
See more

Part and Inventory Search

Back
Top