View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kaye Kaye is offline
external usenet poster
 
Posts: 16
Default ListBox Selection to fire Macro


Hi - Is it possible to have a dropdown box (listbox/combobox?) of 13
text choices, with each choice assigned to a macro?

Ideally I'd like to run one of 13 macros depending upon what the user
selects from this dropdown box.

My present method is using 13 checkboxes with a different macro
assigned to each - the user ticks it, and my macro fires. This though
is occupies too much screen area.

Any help would be appreciated.

Regards Kaye