On entering a textbox problem ??

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bill Case - 26 Sep 2006 07:07 GMT

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

Reply to this Message

Bob Phillips - 26 Sep 2006 08:10 GMT

Add this code

Private Sub HomePhNTxt28_KeyPress(ByVal KeyAscii As MSForms.ReturnInteger)
If KeyAscii = 32 Then
HomePhNTxt28.Text = HomePhNTxt28.Text & " "
End If
End Sub

Signature

HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

> Hi;
>
[quoted text clipped - 21 lines]
>
> Regards Bill

Reply to this Message

Bill Case - 26 Sep 2006 17:37 GMT

Thanks Bob:

I give myself a big headsap this morning when I read your answer. "I knew
that." The perils of working late at night!!

Regards Bill

> Add this code
>
[quoted text clipped - 33 lines]
> >
> > Regards Bill

Reply to this Message