Dropdown List value triggers macro.

**TJ Saulnier** · 05-09-2013, 10:38 AM

I have a dropdown list at c19 with 4 options. I'm attempting to trigger a msgbox to prompt the user for a secondary piece of data if option 2 is selected.

the following code snippit is what I'm attempting to modify to meet my needs but it doesn't seem to be working:

Please Login or Register  to view this content.

Any assistance would be appreciated. When I pick an item from the list I get a compile error sub or function not defined.

**Andy Pope** · 05-09-2013, 10:47 AM

The obvious question then is do the macros MarcoA, MacroC, MarcoD and Get_WO_NUM exist?

**MickG** · 05-09-2013, 10:56 AM

It works for me.
As it says "Sub Or function not Defined" it would point to one of those Subs (Call ---) not existing , Are they ????

**TJ Saulnier** · 05-09-2013, 11:03 AM

I'm Sorry .. I did create the macros however they don't have any code in them as yet ... so the following code is in module1

Please Login or Register  to view this content.

the goal is simply to prompt the user for a value and place it in C47 if they select option 2 from the list.

**TJ Saulnier** · 05-09-2013, 11:07 AM

As you've likely guessed I'm not a programmer .. having created the empty macros as defined above it now errors out on this line

Please Login or Register  to view this content.

Method 'Range' of object'_Worksheet' failed

is the error message.

**MickG** · 05-09-2013, 11:13 AM

Change the code as shown in red:-

Please Login or Register  to view this content.

**TJ Saulnier** · 05-09-2013, 11:25 AM

That's going to do it. It works fine now and I very much appreciate the assistance MickG. I had to make a small adjustment to the data validation for the dropdown but it works perfectly ... thanks again and have a great day.