Setting the focus to the WS when displaying a form

David Looney

Board Regular
Joined
Aug 12, 2006
Messages
60
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
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

David Looney

Board Regular
Joined
Aug 12, 2006
Messages
60
Thanks but thats what I'm doing and although it does select the cell the focus is still on the user form.

thanks
 
L

Legacy 98055

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

Legacy 98055

Guest
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,462
Messages
5,528,950
Members
409,848
Latest member
Blomsten
Top