vba courses london - Dropdown menus & VBA

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Dropdown menus & VBA

Kara has attended:
Excel Advanced course
Excel VBA course

by - delegate Kara [3 posts] (2007 May 18 Fri, 09:53) Reply

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

by - trainer David gold contributer [428 posts] (2007 Jun 1 Fri, 10:50) Reply

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

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Good coding practice

It is important that you always comment the VBA code that you write. By doing this it will make the code much easier to read, as both yourself and other people will be able to see what the code is doing or meant to be doing. This is very important if there is more than one person who writes code in the company as you may have different styles of coding and may not really understand what the other person is trying to do. Also if you write some code and then do not touch it for a year or so you may actually forget what it is meant to be doing. so it is very important to include comments throughout your code and try and make sure that they are as useful as possible

View all VBA hints and tips