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

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