problem running macro with drop down

[dannymc]

Im using excel 2003 on XP

im trying to run a macro for an excel file and one of the steps involves selecting an option from a drop down list. however whenever i try to record this step it is not recorded in the macro, there is no code generated for it.

the file im working on was created by someone else. the drop down menu doesnt appear like a standard drop down menu though. It produces a menu with only "assign macro" and "format control" options. there seems to be no option to edit the code behind it. does anyone know how this was created and how i can record a macro for it?

[dominicb]

Good morning dannymc

...and welcome to the forum.

The macro recorder won't record actions that manipulate user defined objects. If that object has an effect on another cell a VB variable (eg, changes cell A1 to True) then you must capture that change.

HTH

DominicB

[dannymc]

thanks dominic

how do i capture that change?

[dominicb]

Hi dannymc

You really need to post more information for a more relevant answer but sticking with my example. place the word "Why" without quotes in cell A1 and run the macro. Then change A1to "When" and run it again. Any other word will not illicit a response :

Please Login or Register  to view this content.

HTH

DominicB