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

[philldav]

Great lesson thanks very much

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

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