2 calls (month and year) to be combined as date in single cell

I want to use 2 combo boxes on a VBA form, one to specify a month, the
other to specify a year. I want Excel VBA to take these two pieces of
information (month and year) and put them as a date into *one single
cell* in the format "December 2004"


---
Message posted from http://www.ExcelForum.com/

Hi,

Easy. Say your target, or LinkedCell, for Month is
cell G1 (December); and the target for your Year combo
box is G2 (2004);You want the final result in A1.
A1 should read =G1 & " " & G2

jeff

-----Original Message-----
I want to use 2 combo boxes on a VBA form, one to
specify a month, the
other to specify a year. I want Excel VBA to take these
two pieces of
information (month and year) and put them as a date into
*one single
cell* in the format "December 2004"


---
Message posted from http://www.ExcelForum.com/

.