Create a list of month names somewhere in your workbook, and name it
(InsertNameDefine...) say Months.

Then use Data Validation (DataValidation) with a type of list and a value
of =Months.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"Hari" wrote in message
oups.com...
Hi,

I want to offer user with a window containing names of the months in a
year seperately on each line.

The user would choose one of the 12 and press something like ok and I
want the month chosen by the user to be stored in a variable in my
code.

If I can get some skeleton code for similar situation I can try to
customise this for my requirements.

Please guide me as to how I may achieve the same.

Regards,
HP
India