formating textbox

JG · May 10th, 2002, 12:11 PM

Hello,
I am trying to format a textbox to
display a date as 05/10/02, but it covert it to the excel numbering of dates 46232 how do I change this .....Thanks

Brian from Maui · May 10th, 2002, 12:56 PM

JG,

I've been trying to replicate your problem with the text box and can't seem to get Excel to express the date as 46232. Are you using the text box from the Drawing toolbar?

dk · May 10th, 2002, 12:59 PM

Hi,

What's your code? You can use something like this but it depends on how your form is set up:-

Private Sub TextBox1_AfterUpdate()
Me.TextBox1.Text = Format(Me.TextBox1.Text, "mm/dd/yy")
End Sub

Regards,
Dan

JG · May 10th, 2002, 01:41 PM

Maybe thats my problem I haven't written any code could someone give me a basic example of formatting a textbox .....Thanks

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 12:11 PM	#1
JG New Member Join Date: May 2002 Posts: 4	Hello, I am trying to format a textbox to display a date as 05/10/02, but it covert it to the excel numbering of dates 46232 how do I change this .....Thanks

May 10th, 2002, 12:56 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	JG, I've been trying to replicate your problem with the text box and can't seem to get Excel to express the date as 46232. Are you using the text box from the Drawing toolbar?

May 10th, 2002, 12:59 PM	#3
dk MrExcel MVP Join Date: Feb 2002 Location: Sydney, Australia Posts: 2,908	Hi, What's your code? You can use something like this but it depends on how your form is set up:- Private Sub TextBox1_AfterUpdate() Me.TextBox1.Text = Format(Me.TextBox1.Text, "mm/dd/yy") End Sub Regards, Dan

May 10th, 2002, 01:41 PM	#4
JG New Member Join Date: May 2002 Posts: 4	Maybe thats my problem I haven't written any code could someone give me a basic example of formatting a textbox .....Thanks