Input masks on forms within excel,

[Chance1234]

Im sure i've seen something on this forum before but alas cant not find it from the search.

Im coding in excel, using a windows form and i want to add a input mask to a textbox for example to allow entry of a telephone number



Chance,

F, G + _HH

 

[SkipVought]

Chance,

1) Please do not enter phone numbers as NUMBERS. They are IDENTIFIERS; insert all the necessary character delimiters.

2) If it were US format, I'd use 3 text boxes: [3-digit Area Code], [3-digit Exchange], [4-digit suffix] and then insert into my db as...
[tt]
nnn-nnn-nnnn
[/tt]


Skip,

_{When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen!}

 

[Chance1234]

Problem is here, I have about a 100 fields that require inputing and pretty much all of them are going to require some sort of rule. (mainly reference numbers being entered)

Now whilst I can use the change events etc.

I'm pretty sure someone once posted up here away of doing input masks on a windows form.



Chance,

F, G + _HH