formating textboxes in userforms

I hate saying the word "impossible" on this board as it's usually a good way to get shot in the face, but I'm pretty sure this is one of those situations!

As far as I know, you can't do it.
You can restrict what people enter, even down to the keystrokes (http://www.mrexcel.com/board/viewtopic.php?topic=14368&forum=2) but formatting is out.
I think you have to have code in the userform to check the validity of what has been entered.
Could you use If statements in your code using the IsNumeric or IsDate or whatever else functions to do the same job?

What do the rest of the gurus say??

Rgds
AJ

Howdy folks, if your textbox is named textbox1, you can use the BeforeUpdate event (code stored in userform module) to format your text entry. It will convert your number (i.e., .2 = 20%)<pre>
Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
Me.TextBox1.Value = Format(Me.TextBox1.Value, "0.00%")
End Sub</pre>

Similar procedure for other types of formatting. Hope this helps.

Edit: A workaround for the % conversion looks like:<pre>
Private Sub TextBox1_BeforeUpdate(ByVal Cancel As MSForms.ReturnBoolean)
Me.TextBox1.Value = Format(Me.TextBox1.Value / 100, "0.00%")
End Sub</pre>
_________________
Cheers,<font size=+2><font color="red"> Nate<font color="blue"> Oliver</font></font></font>
This message was edited by NateO on 2002-07-15 17:16

I hate saying the word "impossible" on this board as it's usually a good way to get shot in the face, but I'm pretty sure this is one of those situations!

Click to expand...

BANG! Right between the eyes!

nice one Nate!