Worksheet change

[jwlabno]

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

 

[Debra Dalgleish]

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 here:

http://www.contextures.com/xlDataVal08.html#Change