Forms format

Phil C · Apr 29th, 2002, 03:08 PM

I have a form with several text boxes. Is there any way of changing the format when it is transferred into the workbook. I need some to be formatted as text, others as numbers, one as currency and one as date.

Todd_M · Apr 29th, 2002, 03:14 PM

Select the cells on the sheet that needs to bo formated and go to format/cells from your menue. there you can format those cells as you wish.

Mark O'Brien · Apr 29th, 2002, 03:14 PM

When you say "it" is transferred to the worksheet, I'm assuming you mean the text in the textbox?

Have a look at the "Format" command in VBA help.

HTH

Todd_M · Apr 29th, 2002, 03:16 PM

Or you could do it in code:

Format((Range("j2").Value), "$#,##0.00")=TextBox1.Text

Phil C · Apr 29th, 2002, 03:23 PM

I was hopeing that there would be a setting in the textbox properties that could be changed. I have tried using code and the date worked fine but not the others.

Thanks

Todd_M · Apr 29th, 2002, 03:24 PM

Change that to:

Range("j2")=Format((TextBox1.Text), "$#,##0.00")

Phil C · Apr 29th, 2002, 03:33 PM

Thanks Todd_M
Your second code worked perfectly.

Apr 29th, 2002, 03:14 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	When you say "it" is transferred to the worksheet, I'm assuming you mean the text in the textbox? Have a look at the "Format" command in VBA help. HTH __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

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

Apr 29th, 2002, 03:08 PM	#1
Phil C Board Regular Join Date: Apr 2002 Location: NSW. Australia Posts: 64	I have a form with several text boxes. Is there any way of changing the format when it is transferred into the workbook. I need some to be formatted as text, others as numbers, one as currency and one as date.

Apr 29th, 2002, 03:14 PM	#2
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Select the cells on the sheet that needs to bo formated and go to format/cells from your menue. there you can format those cells as you wish.

Apr 29th, 2002, 03:16 PM	#4
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Or you could do it in code: Format((Range("j2").Value), "$#,##0.00")=TextBox1.Text

Apr 29th, 2002, 03:23 PM	#5
Phil C Board Regular Join Date: Apr 2002 Location: NSW. Australia Posts: 64	I was hopeing that there would be a setting in the textbox properties that could be changed. I have tried using code and the date worked fine but not the others. Thanks

Apr 29th, 2002, 03:24 PM	#6
Todd_M Board Regular Join Date: Feb 2002 Posts: 117	Change that to: Range("j2")=Format((TextBox1.Text), "$#,##0.00")

Apr 29th, 2002, 03:33 PM	#7
Phil C Board Regular Join Date: Apr 2002 Location: NSW. Australia Posts: 64	Thanks Todd_M Your second code worked perfectly.