Currency in text box

[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
+----------------------------------------------------------------

 

[Henry]

Chimp,

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


HTH
Henry