Search results for query: *

Thanks!

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...

Ok I'll try that

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

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

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...

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

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...

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...

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...

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...

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

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...

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...

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

Let say, I would need another set in the same worksheet, but this time use a drop-down list. By the way, 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". Thanks

e.g. I would one to monitor another cell change change event in the same worksheet via the change worksheet event

Would I be able to put another set of these code in the same sheet? Thanks

Ok, thanks. I'll try them out and let you know.

P.S. I've attached the Sample_Updated2, thanks you (above)