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 with a drop box. The drop box has all of the worksheets in
the workbook, so when the user clicks the worksheet name, it will become the
active workbook on the screen. So far, so good.

After I drop down the drop box and select the worksheet name, I want the
active worksheet to have the focus, not the userform. However, the cursor
stays in the drop box and I have to manually click in the worksheet to get
the focus there. I have used ActiveSheet.Select, but the focus stays with
the userform drop box.

Any ideas.

Thanks,