Activating a UserForm TextBox

**aca** · 07-25-2011, 11:52 AM

I have a UserForm that includes a TextBox.
When I type characters inside this TextBox, a macro is called that triggers a search for the chain entered so far.
But each time I must begin by clicking inside theTextBox before I can type in it.
Could I include in a macro some code that will perform that clicking and leave the TextBox ready to be typed in?

Thanks for any help.
ACA

**john55** · 07-25-2011, 12:01 PM

hi aca,
try this n see if it helps

Please Login or Register  to view this content.

**aca** · 07-25-2011, 12:31 PM

Thanks, John55. The line you suggest does change something, but it doesn't activate or select my TextBox.
As it is now, my macro ends by selecting one particular cell (which is ready to be typed in).
With the code you suggest that cell becomes inactive (cannot be typed in),
and my UserForm gets a new color shadow; yes, but it does not become selected. to be typed in, which is what I need. What I type doestn't get entered anywhere.
I sense, though, that you are close to the solution; one more try perhaps?
ACA

**john55** · 07-25-2011, 01:05 PM

hi aca,
that line of code works for me, it focuses textbox1.

**aca** · 07-25-2011, 02:51 PM

Thanks again. Yes, I see yours does work all right. But mine still doesn’t.
If you would be so kind as to have a look at the attached sample…

That is the shell of only the relevant sheet of my workbook (a book-keeping program of sorts -in Spanish).
My UserForm appears on opening the file (code for Workbook).
I’ve stripped my workbook of all its macros and of the code for each worksheet as well as of the code for all the buttons inside the UserForm except the TextBox.
In the code window of Excel you can see how I tried to apply your suggestion (code for the TextBox).
Perhaps you will find where I am at fault. Thanks for your ongoing help.
ACA

**john55** · 07-25-2011, 03:15 PM

hi aca,
as i see the name of yr textbox is Busc, see if it helps u

Please Login or Register  to view this content.

**aca** · 07-25-2011, 03:59 PM

Right! That works perfectly.
I feel most grateful for your perseverant toturing (as I say in adding to your reputation).
Thanks again.
ACA

**john55** · 07-25-2011, 04:05 PM

glad to help u! thx for rep!

If you are satisfied then please mark your thread as asolved as follows:
Click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.