Userform format question

[robfo0]

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]

Yes, you can.

For example:

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

 

[Juan Pablo González]

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

 

[Mark O'Brien]

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]

thanks yet again Juan

 

[Ivan F Moala]

Another under rated help source F1 while in
the VBA Editor


Ivan