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
|