Formatting Textbox

  • Thread starter Thread starter MarkVan
  • Start date Start date
M

MarkVan

I have a listbox and a few text boxes. When I click on the listbox it fills
in the appropriate fields in the text boxes. I am trying to format the
textbox. One of the fields is a phone number and the other is a date.

I have tried this

format(txtPhone.text, '999-999-9999')
txtDateofBirth.txt

Nothing works. Please advise if this is possible using VBA
 
Something like:

txtPhone.Text = Format(txtPhone.Text, "000-000-0000")
txtDateofBirth.Text = Format(txtDateofBirth.Text,"m/d/yyyy")
 
Back
Top