Thread: Userform- Formating numbers in Textboxes
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
  
Posts: 5,302
Default Userform- Formating numbers in Textboxes
Hi Ozgar,

With TextBox1
. Text = Format(.Text, "##,##0.00")
End With


Better, as Bob shows, to format the input data directly.


---
Regards,
Norman


Reply With QuoteReply With Quote