Forum Discussion
jorgeliber
Sep 07, 2022Copper Contributor
Change date format of VBA userform textbox data
I have a textbox in a userform. . When I pick the date "12-10-2015" in the userform, the date is loaded into a textbox. This textbox say 12-10-2015. Exactly how I need it. However, when I populate...
jorgeliber
Sep 07, 2022Copper Contributor
Subodh_Tiwari_sktneer plis help me sir
Subodh_Tiwari_sktneer
Sep 08, 2022Silver Contributor
Try to change the Number Format of the cell before writing the date in it like this and see if that works for you...
Sheets("Datos").Cells(ultfila, 3).NumberFormat = "dd/mm/yyyy"