Data Validation 6 - 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.

Have a great day!

[aquayum]

Great Video Mate,

I work as Managment Accountant, so I'll be using to implement it at my work place for creating drop menus and then linking it to my macros for
my expenditure reports

[rachelhastie]

Thank you so much, I have been working on this for a day and a half!!

[TeachExcel]

@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.

[mariuszkrukar]

Nice, do you know as thing stands, when I use i.e. 300 or 400 macros? Is it still doable or should I use another code?

[daljeetsingh]

I have 2 Dropdown List with the same options (Included and Excluded) in different sheets. If I select " Included" in one dropdown list, it should also select "Included" on another dropdown list and vice versa. I am new in coding please help me out to crack this.

[JJSAvi]

When I added a copy and paste code under the Case I encountered Run-time error '438': Object doesn't support this property or method. Do you know what that means???

[stenli]

What if I don't want to run macro on each change on worksheet? Just once drop down menu item is changed?
I want to work in worksheet and, once another item is picked, I want macros to run.
Thanks in advance

[olimakiella]

How do you get the macro to apply to all cells in a column.  We are doing data entry so the drop down list is repeated throughout column BL for every record.  Is there a way to edit the macro so that this can be applied?

[mustafaali]

Hi Sir, i have prepared the sheet in which all the data for employee changes as per the drop down selection. I have done this through vlook up. now i would like to print all the employees sheet. which coding i have to use. please inform. I have more than 100 employees fyi

[Dhugone]

Hi: I have used this macro to hide cells in a spreadsheet. The problem I have now is,  if I select any cell in the worksheet and enter any value the macro kicks in and the curser ends up at rows 32:39. I am a real novice at this so any help would be good  as I am trying to set up a smart form.Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)Select Case Range("G31")Case "**DROP LIST**"
    Rows("32:39").Select
    Selection.EntireRow.Hidden = True
Case "YES!"
    Rows("32:39").Select
    Selection.EntireRow.Hidden = False
Case "NO"
    Rows("32:39").Select
    Selection.EntireRow.Hidden = TrueEnd SelectEnd Sub

[pablillocreazyhorse]

Please help. Your case Select Works justo fine. I use it to run a font color change. It Works just fine when a Select from the dropdown list, the font color changes, but for that Row only, when I change it to run selecting the worksheet, it gives me a runtime error 13.
What gives? Works just fine for one Row, but for all the rest of the rows, error 13.
How can I fix this?
Help!

[shwetan]

Is there a simple way to add this data validation with macros in the rows below?

[NicholasDeasy]

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.

[JamalMiknas]

It worked but the message box does not disappear only after 20 ok clicks. can you help?

[sremmes]

I'm having a problem when I click or into and press enter into a another cell, it runs the macro automatically without my toggling down on the drop down. How can I prevent this using VBA?

[sameerhejen]

can i tell about macro programming what is using this programme

[Wakiema]

Can I do the same with an option button?

[samsamim]

How to compare Data validation and Macros in Excel.

[pablillocreazyhorse]

I ser you dont Pay Any atention in the questions your subscribers do...!