VBA to run macro based on drop down selection sheet.

**shiva_reshs** · 10-26-2013, 05:06 AM

Hi,

I have a dropdown selection in column L2. I need macro to run based on the selection i do in this dropdown.
Any codes for this plz..

Thanks

**strud** · 10-26-2013, 07:24 AM

Assuming you mean cell L2 if you stick this code on the worksheet (not a module) then this will run a macro when any selection is made in the drop down box in L2:

Please Login or Register  to view this content.

You would then have to make your macro dependent on a particular condition

If that doesn't make sense please upload a sample workbook

Regards,
Strud

**shiva_reshs** · 10-28-2013, 02:58 PM

Thanks. Works well.

**strud** · 10-28-2013, 03:02 PM

your welcome

don't forget to hit the star if you found it helpful

**shiva_reshs** · 10-28-2013, 03:04 PM

Already done that Mate!

Thanks for the quick response..
Regards,

VBA to run macro based on drop down selection sheet.

LinkBack

Thread Tools

Rate This Thread

Display

VBA to run macro based on drop down selection sheet.

Re: VBA to run macro based on drop down selection sheet.

Re: VBA to run macro based on drop down selection sheet.

Re: VBA to run macro based on drop down selection sheet.

Re: VBA to run macro based on drop down selection sheet.

Thread Information

Users Browsing this Thread

Similar Threads

Transferring data based on drop down selection to another sheet on the same workbork

[SOLVED] Looking for an easy way to change data on a sheet based on drop-down selection

Copy cell range from another sheet based on drop down selection.

Using Drop Down in one sheet to push row to next sheet based on Selection

Run macro based on drop down selection

Bookmarks

Bookmarks

Posting Permissions