Thread: Can I assign a macro to each item in a drop-down list?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_7_] Bob Phillips[_7_] is offline
external usenet poster
  
Posts: 1,120
Default Can I assign a macro to each item in a drop-down list?
Assign the macro to the listbox and add this code to that macro

Sheets(ActiveSheet.ListBoxes(Application.Caller).V alue).Select


But the sheet tabs at the bottom also have a list, just right-click the
arrow keys to the left of the tab names.

--
HTH

Bob Phillips

"jbp20717" wrote in
message ...

How would I go about that? ;)


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