View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronny Hamida Ronny Hamida is offline
external usenet poster
 
Posts: 16
Default Macro to allow user to "choose" a month from a list

Hi there!

I am in need of a macro to allow a user to choose a month from a list of
months (as opposed to letting them type in the month). Because this macro
will be added to another macro program that I already have, I will also need
the user's selection to be saved as a global variable.

For some reason, I was thinking of using something like MsgBox or InputBox,
but you cannot define the buttons to the degree of letting the user actually
click on a particular month. The buttons are set values (Ok, Cancel, etc.)

Any ideas?

Thanks in advance!

Ronny