Currency in text box

  • Thread starter Thread starter chimp
  • Start date Start date
C

chimp

How can i get a text box to be displayed as currency instead of jus
numeric on a userform.

you will see from the attached picture that the recommended sellin
price which works from a vlookup displays the Currency £ symbol,

where as the text box which is a manual entry does not.

Please Help

And

+----------------------------------------------------------------
| Attachment filename: text box.gif
|Download attachment: http://www.excelforum.com/attachment.php?postid=365653
+----------------------------------------------------------------
 
Chimp,

Try
Private Sub TextBox1_AfterUpdate()
TextBox1.Text = "£" & TextBox1.Text
End Sub


HTH
Henry
 
Back
Top