Well!, if you are using only the validation with source list (or so),
then the worksheet_change event to trigger your code. Selecting a value
from the dropdown is actual 'WorkSheet_Change" event, not 'Calculate'
event.
(Calculate event may occur as a consequence if you have any further
formula involving the cell in question.)

1. Did you enter the code in Sheet1 - Worksheet_Change event procedure
as it appears in VBE (Class module) or not?

2. Check that when you are trying to fire your code, you are not still
in Design mode. Exit Design mode and try.

Sharad



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!