G
Guest
I have a UserForm that has a drop box with all of the worksheet names in the
drop box. When the user clicks the worksheet name, that worksheet becomes
the active sheet on the screen.
However, the cursor focus stays in the drop box and I want the focus and the
cursor to go the the worksheet. The UserForm should lose the focus and Excel
and the worksheet should get the focus. NO LUCK!
Please help.
drop box. When the user clicks the worksheet name, that worksheet becomes
the active sheet on the screen.
However, the cursor focus stays in the drop box and I want the focus and the
cursor to go the the worksheet. The UserForm should lose the focus and Excel
and the worksheet should get the focus. NO LUCK!
Please help.