worksheet change event

  • Thread starter Thread starter gautamvt
  • Start date Start date
G

gautamvt

hi,

I added some code to worksheet_change event and added a validation
rule(data validation..from tools..validation) using a List.
Now my problem is when I select a value from the list the worksheet
change event is not triggered. but if I type any thing in the cell then
this event is triggered. please can anyone tell me why worksheet change
event is not getting triggered when I select any value from thelist and
why it is triggered only when I type something in the cells.

PS: Iamnot looking at "Selection change"

Thanks a lot.
Gautam
 
If you are using Excel 97, then this was a bug. It was fixed in xl2000 and
later to the best of my knowledge.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Include Dropdowns and Checkboxes in Worksheet Change event 1
On-sheet activeX component disables copy/paste 6
Trapping value before and after change 3
Fire Worksheet_change event from module 3
RAND() Won't Trigger Worksheet_Change 5
Run VBA code only worksheet change, but don't trigger worksheet_change event based on what the code 6
Worksheet Activate event not firing 4
Data form not triggering Worksheet_Change event 3

Back
Top