LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rufusf
 
Posts: n/a
Default running a macro from a list


Hi I'm new here.. hopefully somebody can help me with this qeuery...!

I have a list in a worksheet (using 'validation' from the 'data' menu).
I want to run a macro depending on what option is selected from the
list

i.e. if you select 'sheet 1' then the macro called 'macro1' will run...
if you select 'sheet 2' then the macro called 'macro2' will run...etc

is this possible?

many thanks

rufusf


--
rufusf
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Status bar (or similar) to appear whilst running a long macro Ant Excel Discussion (Misc queries) 8 November 11th 05 09:21 AM
calc locks up after running a macro that moves sheets to a new fil shibao Excel Discussion (Misc queries) 0 November 7th 05 10:58 PM
Data Val list Excel 97 fire macro rgarber50 Excel Discussion (Misc queries) 4 October 9th 05 05:19 PM
How to show dropdown list from another workbook without running it Kuche Excel Discussion (Misc queries) 1 June 29th 05 07:05 PM
How to create a macro that compares a list to another list Rampa New Users to Excel 1 January 13th 05 01:15 PM


All times are GMT +1. The time now is 10:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"