funny calculations

[big t]

Hi everyone,

I'm working in Excel 2003 and I have a workbook with a dropdown box on it.
In this particular situation the dropdown is disabled and not visible.

Where I have Calculate in my VBA or when I switch the calculation mode
between manual and automatic it seems the code thinks the dropdown box has
changed and it runs the code associated with such a change.

Any ideas?
TIA
big t

 

[BrianB]

Generally we need to have a global variable that will skip the dropdow
code using something like :-


Code

 

[Tom Ogilvy]

Put your event code in the click event rather than the change event.

 

[big t]

thanks for your suggestions, i'll try them out...

cheers
big t