funny calculations

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Generally we need to have a global variable that will skip the dropdow
code using something like :-


Code
 
Put your event code in the click event rather than the change event.
 
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

VBA - how do I pass info from dropdown list to a string?? 1
MsgBox saying Excel is calculating 5
Excel 2007: getItemLabel not working 3
Looking for some help launching files from COde & Ribbon control 0
Excel Add-In to catch application events 1
VBA to run all variable combinations in a calculation model and store result 6
Code to select active workbook worksheet(s) in Excel 2007 2
Named Range not appearing in names drop down 5

Back
Top