Previous Topic Next Topic

Converting date in VBA Excel

Solved/Closed
Roger - Dec 27, 2010 at 01:48 PM
 Roger - Dec 28, 2010 at 01:54 PM
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!

3 responses

Answer 1 / 3
pshycozak
Dec 28, 2010 at 07:22 AM
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.
0
Answer 2 / 3
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Dec 28, 2010 at 09:32 AM
Hi Roger,

Looking for something like this: 

ActiveCell.Formula = "=DATE(A2,B2,C2)"
Best regards,
Trowa
0
Roger
Dec 28, 2010 at 11:29 AM
Thanks Trowa worked like a charm at first but now I am getting the error: #VALUE!. I have formatted the cells over and over I just don't know what the heck is going on! Can't I just format the cells to General? The cell that has the formula for the date I have set to the Date format.
0
Answer 3 / 3
Roger
Dec 28, 2010 at 01:54 PM
Problem solved thanks so much!
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses