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

  • Thread starter Thread starter Andigo
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Extract month from date 2
Combine month day and year from separate columns in to one cell 3
Convert Text to Date Month and Year 1
Access 2 Digit year in Access Text Box 3
Return Month & Year of Date Value 1
Date in cell keeps adding the current year. 6
Date and years calculation 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2

Back
Top