Setting the focus to the WS when displaying a form

[David Looney]

After I display a modeless user form, I want the focus on the worksheet (not the user form) so the user can move around without having to click the worksheet first. Anyway to do this?

Thanks

 

[Legacy 98055]

UserForm1.Show vbModeless
ActiveCell.Activate

 

[David Looney]

Thanks but thats what I'm doing and although it does select the cell the focus is still on the user form.

thanks

 

[Legacy 98055]

Where is your code? In the initialize event? If so, place it somewhere else.

 

[Legacy 98055]

Please post your code and provide other info as to how you are showing your userform. From a button, other event procedure, ect..

I cannot duplicate your problem.

 

[Ivan F Moala]

UserForm1.Show vbModeless
AppActivate ("Microsoft Excel")