CommandButton to return to TextBox

[Anarchus]

Hi there,

I have a TextBox on a spreadsheet which is used to search for items. I also have a commandbutton that will "Clear" whats in the textbox so you don't have to manually delete every character.

Currently, when you click the "Clear" button, the textbox clears but then you have to click on it again to begin typing. Is there something I can add into the following (very simple) code so that when you click on "Clear", the cursor automatically returns to the textbox and you can begin typing again?

Please Login or Register  to view this content.

[Winon]

Hello Anarchus,

Try;

Please Login or Register  to view this content.

Regards.

[Anarchus]

Hi Winon,

I didn't know it was that simple. Thanks so much!

[Winon]

You are welcome Anarchus, glad I could help.

Thank you for marking the Thread as Solved!

Regards.