Hi all,
I am trying to find a way to have the date entered in the input-box from the user-form appear in specific formatting in designated cell, however i am often having day and month swapping places and cell formatting not working for me.
The code i have now is:
startday.Value = Format(startday.Value, "dd/mm/yyyy")
Sheet4.Range("d" & Rows.Count).End(xlUp).Offset(1, 0).Value = startday.Value
Startday is input-box caption
Can anyone please assist?
Regards
Filarap
I am trying to find a way to have the date entered in the input-box from the user-form appear in specific formatting in designated cell, however i am often having day and month swapping places and cell formatting not working for me.
The code i have now is:
startday.Value = Format(startday.Value, "dd/mm/yyyy")
Sheet4.Range("d" & Rows.Count).End(xlUp).Offset(1, 0).Value = startday.Value
Startday is input-box caption
Can anyone please assist?
Regards
Filarap