View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Albert Albert is offline
external usenet poster
 
Posts: 203
Default Formatting a textbox

Hi Guys,

Just a quick question.

How do I format a textbox value when a user enters the textbox?

Private Sub TextBoxCustcontactnmbr_Enter()
TextBoxCustcontactnmbr.Text = Format(TextBoxCustcontactnmbr.Text,
"###-###-####")
End Sub

I want the number to appear 999-999-9999

Thanks
Albert