Converting date in VBA Excel Solved/Closed

Question

Hello, 

I have a spreadsheet that has:

Column A: Year
Column B: Month
Column C: Day

Is there a way to convert these 3 columns into the actual date in VB code?  I have a form that I need a text box to populate the date from these three columns in the spreadsheet.  The reason I simply did not use the date format in the spreadsheet is because the user will be filtering many dates and I was afraid the advance filter would be a little more complicated for them.  Thanks if anyone can help!  

Configuration: Windows 7 / Safari 534.10

pshycozak · Answer

I dont know how to do that in VB code but you can use such a formula 
=B1&"/"&C2&"/"&A2
and change the format of the cell to date
I hope it helps.

TrowaD · Answer

Hi Roger,

Looking for something like this:

ActiveCell.Formula = "=DATE(A2,B2,C2)"Best regards,
Trowa

Roger · Answer

Problem solved thanks so much!

Converting date in VBA Excel

3 responses

Similar discussions

Subscribe To Our Newsletter!