#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!!
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA userform jcheko Excel Worksheet Functions 1 April 24th 08 08:38 PM
userform carwincarber New Users to Excel 0 October 23rd 05 06:59 PM
userform Aashi Excel Programming 2 April 25th 04 06:39 PM
Userform inside another userform Ryan Excel Programming 0 April 23rd 04 08:01 PM
Userform Help Pete[_13_] Excel Programming 1 November 14th 03 10:03 PM


All times are GMT +1. The time now is 06:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"