ExcelBanter - Formatting a textbox

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Formatting a textbox (https://www.excelbanter.com/excel-programming/405293-formatting-textbox.html)

Albert

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

Per Jessen

Formatting a textbox

Hi Albert

I am not sure what you want to do, but I think that I would format the
textbox when the user leaves it.

I.e.
Privat sub Textbox1_exit()
.....

Regards,

Per

"Albert" skrev i en meddelelse
...
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

All times are GMT +1. The time now is 09:51 AM.