lhtqasonline
01-22-2009, 04:34 AM
Hi all
I'm using a userform to update existing cells in worksheet.
i have a date textbox and need formatting to apply to it.
Don't know if my question makes sense but here goes:
how do i change the code
Range("A1").NumberFormat = "dd/mm/yyyy"
to work on a textbox called DateContact
something like
Me.DateContact.NumberFormat = "dd/mm/yyyy"
obviously NumberFormat cannot be used with Me.DateContact as it only works when referring to a Range
Newbie
I'm using a userform to update existing cells in worksheet.
i have a date textbox and need formatting to apply to it.
Don't know if my question makes sense but here goes:
how do i change the code
Range("A1").NumberFormat = "dd/mm/yyyy"
to work on a textbox called DateContact
something like
Me.DateContact.NumberFormat = "dd/mm/yyyy"
obviously NumberFormat cannot be used with Me.DateContact as it only works when referring to a Range
Newbie