View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default $ format in cell

Todd,

Here's one way


Private Sub TextBox1_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
Static flag As Boolean

If flag < True Then
TextBox1.Text = "$" & TextBox1.Text
flag = True
End If

End Sub

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Todd Huttenstine" wrote in message
...
Hey guys I had a code that did this but now I cant find
it!!!

What it does is as I type in a textbox it will put the $
sign in front of the number. So if I go to a textbox and
type 135, the dollar sign will be there at the front even
as I am typing.