Forum Discussion
Displaying a date using an excel vba macro
Hello. I've formatted a 4-digit numeric field 0 decimals which contains the year 2024 in cell E2. The user can change this value as needed. I am concatenating the month and the day using the DateSer...
I'm by no means a VBA expert. Just change line where you pick-up the year number to:
Then it will work.
- Hi Riny,
Thank you for your help!
I made the change. It works!
Also, I used Nikolino's code
to change the last year entry
to Curryear = Curryear + 1.
Thank you all for your help since date
fields are so difficult to work with.
From Tommee
