Hi
I have a textbox which uses a date value in a cell from the spreadsheet. At the moment it shows the value of the cell as m/d/yy how do I get it to view dd/mm/yy?
Hi
I have a textbox which uses a date value in a cell from the spreadsheet. At the moment it shows the value of the cell as m/d/yy how do I get it to view dd/mm/yy?
Try using a textbox from the drawing toolbar rather than from the control
toolbox toolbar.
--
Regards,
Tom Ogilvy
"funkymonkUK" <funkymonkUK.1uxmef_1126001144.782@excelforum-nospam.com>
wrote in message
news:funkymonkUK.1uxmef_1126001144.782@excelforum-nospam.com...
>
> Hi
>
> I have a textbox which uses a date value in a cell from the
> spreadsheet. At the moment it shows the value of the cell as m/d/yy how
> do I get it to view dd/mm/yy?
>
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=414234
>
unfortunately I cannot as I am using a userform.
unfortunately I cannot as I am using a userform.
Now I see that in the subject. another example of why it is best to include
all pertinent information in the body.
Private Sub Textbox1_AfterUpdate()
Textbox1.Text = format(Textbox1.Text,"dd/mm/yy")
End Sub
You might have to experiment with other textbox events to see which works
best.
--
Regards,
Tom Ogilvy
"funkymonkUK" <funkymonkUK.1uy32k_1126023244.9104@excelforum-nospam.com>
wrote in message
news:funkymonkUK.1uy32k_1126023244.9104@excelforum-nospam.com...
>
> unfortunately I cannot as I am using a userform.
>
>
> --
> funkymonkUK
> ------------------------------------------------------------------------
> funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
> View this thread: http://www.excelforum.com/showthread...hreadid=414234
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks