cursor is not staying in textbox

[punna111]

Hi all,

I have user form with 2 text boxes. i want to type some line like "I am very happy" in that text box.
I typed "I am" then i pressed Alt + Tab then again i pressed ALT + Tab. i need to type "very happy" now. but cursor is not staying in that text box. again i need to click in that text box with mouse then i need to type.

When i came back to userform that cursor should be there and i can able to type in that text box. how can i do this? is there any vba code for this.

[Leith Ross]

Hello punna111,

In case you didn't know, there are 3 types of TextBoxes: Forms, ActiveX, and Drawing. each has its own properties. You need to identify which type you are referring to.

If you are not sure then post your workbook.

[punna111]

Hi Leith Ross,

Thank you for reply.

please find the attached excel file. try by doing switch windows. cursor is not blinking in textbox. actually it is combo box. it is a example file. please click on a button on sheet1 to see the userform1.

[Leith Ross]

Hello punna111,

Can you explain why the example file does not match with the description in your first post?

Problems Found

1. A ComboBox can not be used like a TextBox.
2. There is no code written for the ComboBox.
3. There are no TextBoxes on the UserForm.

Your results will be only as good as the information you provide.

[punna111]

Hi Leith Ross,

Glad to see your answer.

For 3 problems my answer is:
1) I am unable to paste in a text box from clipboard. but i can paste in combo box that's why i used combo box as text box.
2) I already mentioned in the 2nd post this is a demo file.
3) If the code will only work with text boxes not with the combo boxes, please find the attachment with text box.

[IGEDIT]

Try the following for sheet1:
In the code for commandbutton1 alter to this,

Please Login or Register  to view this content.

in the code for userform1 alter to this,

Please Login or Register  to view this content.

I did not have a problem pasting text into the textbox.

[punna111]

Thank you IGEDIT,


I am able to paste in Text box. but cursor is not staying in textbox when i use alt+tab to switch windows.
is there any code for this?

[IGEDIT]

Will look into that.
Try this in userform1 code.

Please Login or Register  to view this content.

[punna111]

Thank you for your reply,

I am sorry to say, the above code is not working.

[IGEDIT]

The attached file works for me!cursor not.xlsm