Thread: Textbox appearances. Format as $ and %. How?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default Textbox appearances. Format as $ and %. How?
With Userform1
.Textbox1.Text = Range("A1").Text
End With

--
Regards,
Tom Ogilvy


"Corey" wrote in message
...
I have a few text boxes on a userform that display values for allowances,
however $10.00 displays as 10 with no "$" and no 2 decimal values.
Also a 0.09 is displayed in another textbox, however i want it displayed
as "9%".

How do i change the format apperances of these?

Corey....



Reply With QuoteReply With Quote