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

A

Andigo

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

jeff

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
 
Top