Data Validation 6 - Run Macros from Drop Down Menus in Excel

Visit http://www.TeachMsOffice.com for more, including Excel Consulting, Macros, and Tutorials.

Excel video tutorial that teaches you how to run macros from drop down menus in Excel. This Excel video tutorial walks you through the steps you need to take in order to make a macro run when you select an option from a data validation drop down menu in Excel. This includes teaching you how to create the drop down menu in Excel; how to create the basic macro to run based off of the drop down menu; and, how to change the macro to run your own macro code.

This is a really great tutorial to view in order to perform more powerful tasks with your drop down menus and lists in Excel.

For Excel consulting, classes, or to get the spreadsheet or macro used here visit the website http://www.TeachExcel.com There, you can also get more free Excel video tutorials, macros, tips, and a forum for Excel.

Have a great day!

Category:

Education

Tags:

• excel
• macros
• drop down
• menus
• lists
• data validation
• run
• view
• start
• automation

[Virus8EthHax]

Hey @ExcelisHell, great video but unfortunately doesn't work for me.

I'm using Windows 7 with Office Enterprise 2007.

When I complete the VB macro script EXACTLY same as what you've got on the demo, I get an error message "Compile Error: Statement and labels invalid between Select Case and First Case" and then it highlights the very first line in yellow. Any ideas what might be causing this?

[ExcelisHell]

@Virus8EthHax Never used your system before, it might have something to do with VB configuration options. I'd search some Excel forums or google to see if someone has had the issue before.

[philldav]

Great lesson thanks very much

[kiwidiablo666]

That was great thanks.

How do you check for a change in multiple cells i.e. a range containing more than one cells e.g. Range ("a5","a35")

Cheers

[NicholasDeasy87]

how do you input other macros such highlight and color certain cells when a option in the drop down menu is selected? I can get the msgbox working but other macros i insert wont.