Shift focus from a userform to excel

[bydesign]

Hello

How can I shift focus from a visible userform to the excel sheet?

my userform is modeless and
Currently, the last statement in my procedure is...
Sheets("MySheet").Range("B93").Activate

The cell selector is put in the correct place, however the userform still has focus... therefore you must actually click the excel sheet before you can type in the selected cell.

Any ideas on how to programatically shift focus to the excel sheet?

 

[bydesign]

Ivan

Thanks!!! that's the ticket...

 

[Ekim]

mmm.. I have always left the userform’s default property ShowModal as True, but opened the userform with:

UserForm1.Show vbModaless

Still need Ivan’s code in the CommandButton macro to shift focus to the cell.

I’m not sure of the implications, if any, of using:

UserForm1.Show / ShowModal as False
or:
UserForm1.Show vbModaless / ShowModal as True (no difference if set to False)


Regards,

Mike