Hi ,

can any one help me ? I had created the following Userform , with several
textboxes that users would have to key in a $ value.

I managed to get the textbox to display as $0 with the following code

Private Sub txtUT_Change()
Me.txtUT.Value = Format(Me.txtUT.Value, "$###,##0")
End Sub

however, users still can enter text data , which I want to prevent them from
doing so.