Thread: Can I assign a macro to each item in a drop-down list?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jbp20717 jbp20717 is offline
external usenet poster
  
Posts: 1
Default Can I assign a macro to each item in a drop-down list?

Is it possible to assign a different macro to each item in a drop down
list or not?

I've tried something like this, but I am totally useless with
VisualBasic, so I wouldn't be surprised if its totally meaningless:

Sub Larder2()
'
Select Case ("Larder Prep")
Sheets("Larder Prep").Select
Select Case ("Bakery")
Sheets("Bakery").Select
End Sub

...besides, I want to run a range of macros and not select sheets in
the workbook.


--
jbp20717
------------------------------------------------------------------------
jbp20717's Profile: http://www.excelforum.com/member.php...o&userid=24886
View this thread: http://www.excelforum.com/showthread...hreadid=384257

Reply With QuoteReply With Quote