Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet change
Hello,
I just posted worksheet change problem but have since figured out parts of the puzzle. I have input area on the sheet where users can enter data, either by typing or selection boxes. Worksheet Change does not get run if a selection box is used but it does when information is typed manually. How can I make it run for selection boxes as well? When a selection is made the choice is stored in designated cell - which changes the cell's value, why doesn;t worksheet change run? Regards Jack |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Worksheet change
If you're using Excel 97, selecting an item from a Data Validation
dropdown list doesn't trigger a worksheet change event, unless the list has been typed in the Data Validation dialog box. There's some information and workarounds he http://www.contextures.com/xlDataVal08.html#Change jwlabno wrote: Hello, I just posted worksheet change problem but have since figured out parts of the puzzle. I have input area on the sheet where users can enter data, either by typing or selection boxes. Worksheet Change does not get run if a selection box is used but it does when information is typed manually. How can I make it run for selection boxes as well? When a selection is made the choice is stored in designated cell - which changes the cell's value, why doesn;t worksheet change run? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to change the pivot chart automaticaly as values in the worksheet change | Excel Worksheet Functions | |||
VBA Worksheet change name | Excel Discussion (Misc queries) | |||
change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
Help Please, Worksheet Change | Excel Worksheet Functions | |||
Worksheet change | Excel Programming |