vba courses london - Dropdown menus & VBA

Resolved · Low Priority · Version Standard

Fri 18 May 2007, 09:53 Delegate Kara said...

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

Fri 1 Jun 2007, 10:50 Trainer David said...

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Stop Display Alerts In Excel

When creating or deleting a Worksheet in Excel you don't want Excel to inform you "A file already exists....." Or "Do you want to save this file...".

To stop these alerts happening use the following line of code:

Application.DisplayAlerts = False

After the Create or Delete routine use:

Application.DisplayAlerts = True

View all VBA hints and tips