tell em to do it or just use a custom format
###-###-####

--
Don Guillett
SalesAid Software

"Amber_D_Laws"
wrote in message
news:Amber_D_Laws.22vsxy_1139353201.9895@excelforu m-nospam.com...

I was doing some research on how to make my users enter phone numbers
consistantly using the same format and I happened upon the following
page,
http://www.dotnet247.com/247referenc...51/257905.aspx
which seems to be an archived and compiled selection from some forum or
another. In the discussion they talked about using three text boxes, all
with specified lengths and using "auto-focus" on them in succession then
adding in the dashes and parenthises later programaticly.

Sounds great! However, they don't ever say how to accomplish this. As
far as I can tell it is a discussion between experienced programers who
already know how, and they are just talking technique not actual code.
Meanwhile, I am not an experienced coder and I don't know how.

So far it has been the only intelligable anything I have drummed up on
the subject. If anyone has any ideas as to how to actually code what
three text boxes to take focus in succession, and then programaticly
add parenthises and hyphens to the text as it is entered onto an Excel
spread sheet, please let me know.

Any help will be appreciated, even if it is just links to other
relevant topics.

Thanks,
Amber;)


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile:
http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=509591