Thread: UserForm
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Steve Steve is offline
external usenet poster
 
Posts: 1,814
Default UserForm

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.