Thread: Userform
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Rob Rob is offline
external usenet poster
 
Posts: 234
Default Userform

I have a userform with buttons. When a button is clicked,
and the code associated with that button finishes running,
I want the userform to be deactivated (but still remain
visiable), with the underlying worksheet made active.
I've tried activating the worksheet within the code, and
selecting a cell in the underlying worksheet within the
VBA code associated with the button, but the userform
still remains active after the code finishes running.
That is, the user must physically click on a cell or range
in the worksheet for the focus to shift from the userform
back to the worksheet. Any ideas on how I can do this
in the VBA code?

Thanks!!