User Form
 

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.

User Form
 

Got it thanks


-----Original Message-----
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.
.