View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mirja Mirja is offline
external usenet poster
 
Posts: 6
Default InputBox including list of items

Hello!

I would like to write a macro that includes an inputBox.
If you start the macro, the inputBox should pop-up with a
list. Then, I would like the user to choose from a list
that is defined e.g. by the Range "A1:A10".
If the user chooses an item from the list, the macro
should continue with that item, e.g.: user chooses 2nd
item and the macro runs differently than with item 3 or 4.
How can I do it? Can anybody help?
Thanks so much,
Mirja