User Form

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hello All,

I have a user form that inputs data into a worksheet upon
clicking a command button. After I click the button, I
would like my userform to be active (not my spreadsheet)
and the cursor returned to the first tabstop.

BTW:My userform is modeless as other forms can be opened
and utilized.

I think this has something to do with TakeFocus?

Thanks in advance.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modeless dialog box appears twice on screen??? 1
Modeless Userform 2
modeless userform 4
Spreadsheet Component not setting focus 2
How to enumerate buttons on user form 2
VBmodeless user form errant behaviour 3
closing another file by code causes failure to run workbook activate event 2
Set focus on controls of modeless form 4

Back
Top