Kara has attended:
Excel Advanced course
Excel VBA Intro Intermediate course
Dropdown menus & VBA
pls advise how to code using the drop down menus:
i am recording macros to demonstrate various scenarios. in excel the scenarios are determined by the unique value selection from the validated drop down menu.
when i run the macro it shows same results for all cases because it 'omits' the "drop down the menu and look for the required value" command.
thanks
RE: Dropdown menus & VBA
Hi Kara
I have not really been able to create exactly what you are working with, so I cannot replicate your error.
Below is a link to a very good VBA website, have a look at it, if you cannot find any thing that solves your problem, get back to me with some of you vba code so I can see what the code is doing.
VBA code help
Hope this helps
David