Keeping focus on TextBox, save with each change

[venkatpvc]

Hello Friends,

I have form, which I use to enter data in Excel.

The thing is I have Form with five comboboxes with one txtbox.

I need a code for to when ever i change text in txtbox, i want that save to sheet. and combobox values remain same till i click clear.
and cursor always needs to be in txtbox till i click on the combos.

everytime i change text in txtbox the cursor moving to next combobox.
so i dont want happen it, i just want cursor stay on txtbox. can anybody help pls?

I am poor at asking questions and help? so if you dont understand my above question pleaes ask me.

thank you,
venkat

[mehmetcik]

The following code inserted into your userform code will do what you need.

I tried using the textbox1.exit code but it didn't work.

Please Login or Register  to view this content.

[JBeaucaire]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.