Thread: displaying input data on user form as currency
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel
JLGWhiz JLGWhiz is offline
external usenet poster
  
Posts: 3,986
Default displaying input data on user form as currency
TextBox1.Value = Format(YourSource, "$##,###.##")

Substitute the Range, Cell or Value that you want to convert as "YourSource".


"mantrid" wrote:

Hello
Im trying to find a property or a way to format a text box on a user form to
show as currency when input. Can't seem to find how to do this anywhere.
Can anyone help
Thanks
Ian



Reply With QuoteReply With Quote