Have you considered using <data< validation <allow list.
No macro required
You will get a dropdown list to choose from.

--
Greetings from New Zealand
Bill K


"Ronny Hamida" wrote in message
...
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