Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA userform | Excel Worksheet Functions | |||
userform | New Users to Excel | |||
userform | Excel Programming | |||
Userform inside another userform | Excel Programming | |||
Userform Help | Excel Programming |