Userform format question

robfo0 · Mar 28th, 2002, 01:20 PM

Hi, me again

another quick question im having trouble finding the answer to. Can i format the values of a userform? I know i can format them when i transfer them to my worksheet, but i would like for example:

If someone inputs 5.00 into a textbox on the userform, the form automatically changes it to $5.00.

also, does anyone know any helpful websites with some userform information? I'd like to read up more. Maybe then i wouldn't have so many questions

Thanks again

Juan Pablo González · Mar 28th, 2002, 01:21 PM

Yes, you can.

For example:

Code:

Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
TextBox1 = Format(TextBox1, "$#,##0.00")
End Sub

Juan Pablo González · Mar 28th, 2002, 01:21 PM

About websites... I don't know... I firmly believe in self help and practice (And of course, asking here !!)

Mark O'Brien · Mar 28th, 2002, 01:46 PM

Self help includes books, I hope. Books are good. I've read a couple.

Learning here is good, but books are better. You'll get better structure using books. This message board is great for getting elusive answers, but books are good.

There are books everywhere.

I'm sorry, it's Holy Thursday and I am completely exhausted. TFI a long weekend.

Also, Juan's been adding onto people's posts all day. It's time for a taste of his own medicine.

robfo0 · Mar 28th, 2002, 01:59 PM

thanks yet again Juan

Ivan F Moala · Mar 28th, 2002, 02:08 PM

Another under rated help source F1 while in
the VBA Editor

Ivan

Mar 28th, 2002, 01:21 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Yes, you can. For example: Code: Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean) TextBox1 = Format(TextBox1, "$#,##0.00") End Sub __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 28th, 2002, 01:21 PM	#3
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	About websites... I don't know... I firmly believe in self help and practice (And of course, asking here !!) __________________ Regards, Juan Pablo González http://www.juanpg.com

Mar 28th, 2002, 01:46 PM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Self help includes books, I hope. Books are good. I've read a couple. Learning here is good, but books are better. You'll get better structure using books. This message board is great for getting elusive answers, but books are good. There are books everywhere. I'm sorry, it's Holy Thursday and I am completely exhausted. TFI a long weekend. Also, Juan's been adding onto people's posts all day. It's time for a taste of his own medicine. __________________ 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

Mar 28th, 2002, 01:20 PM	#1
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	Hi, me again another quick question im having trouble finding the answer to. Can i format the values of a userform? I know i can format them when i transfer them to my worksheet, but i would like for example: If someone inputs 5.00 into a textbox on the userform, the form automatically changes it to $5.00. also, does anyone know any helpful websites with some userform information? I'd like to read up more. Maybe then i wouldn't have so many questions Thanks again

Mar 28th, 2002, 01:59 PM	#5
robfo0 Board Regular Join Date: Feb 2002 Location: Stockton, California Posts: 281	thanks yet again Juan

Mar 28th, 2002, 02:08 PM	#6
Ivan F Moala MrExcel MVP Join Date: Feb 2002 Location: Auckland, New Zealand Posts: 4,209	Another under rated help source F1 while in the VBA Editor Ivan