Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User Form Question...

Status
Not open for further replies.
merlinx

merlinx

Programmer
Sep 20, 2002
170
DE
In Excel, how can I open A user form whichs stays on top, but allows the active work sheet to be used?

Straight off : I need to open the form and the let the user click on certain cells in the active sheet so that I can collect array values.
 
Sort by date Sort by votes
If you have XL2000 or later, you can set the Show modal property of the userform to False, or invoke the userform in the following manner :

UserForm1.Show False

A.C.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Avayacoolstuff
  • Locked
  • Question
MS quick query question
Replies
1
Views
300
PatrickRoggers
PatrickRoggers
Bijugate
  • Locked
  • Question
Excel update question
Replies
0
Views
681
Bijugate
Bijugate
pjw001
  • Locked
  • Question
Question About Outlook Versions 1
Replies
4
Views
1K
stuartjames78
stuartjames78
pmover
  • Locked
  • Question
MS Mac Office Single User License
Replies
3
Views
476
pmover
pmover
tootiredtocare
  • Locked
  • Question
OneDrive - Clean Local Cache For A User Remotely
Replies
1
Views
388
kjv1611
kjv1611

Part and Inventory Search

Sponsor

Back
Top