G
gti_jobert
Hi all,
I have a textbox on my userform and neeeeed it formatted. When the user
enters it I want them to enter a 10 digit number only but also have it
display a '-' in the middle of the number.
for example,
#####-##### (the textbox should always display the '-' in the middle of
the textbox. Is this possible? I have previously tried:
Code:
--------------------
txtPartno.Text = Format(txtPartno.Text, "#####-#####")
--------------------
but have had no joy, any help would be much appreciated.
Taa in advance!
I have a textbox on my userform and neeeeed it formatted. When the user
enters it I want them to enter a 10 digit number only but also have it
display a '-' in the middle of the number.
for example,
#####-##### (the textbox should always display the '-' in the middle of
the textbox. Is this possible? I have previously tried:
Code:
--------------------
txtPartno.Text = Format(txtPartno.Text, "#####-#####")
--------------------
but have had no joy, any help would be much appreciated.
Taa in advance!