ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Userform (https://www.excelbanter.com/excel-programming/300179-userform.html)

Rob

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!!


All times are GMT +1. The time now is 11:12 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com