Hi;

I have a textbox on a Userform for phone numbers. I want to have the most
likely area code placed in the textbox. I don't want to use a listbox. I
have:

Private Sub HomePhNTxt28_Enter()

HomePhNTxt28 = "(613)"

End Sub

When the user tabs into the Textbox the area code is selected (blue
background)and the cursor is at the end of the '(613)' text -- which is what
I want. However when any key is pressed the '(613)' text is deleted --
including pressing the spacebar. I would like to set it up so that deletion
is the result of pressing anything *except* the spacebar.

Pressing the spacebar should only insert a space and then wait for the user
to input the rest of the phone number.

I am afraid that key manipulation is new to me; I can't even thing of how to
properly pose the question on google etc.

Regards Bill