Login or Sign Up
Logging in...
Remember me
Log in
Or
Sign Up
Forgot password or user name?
Log in with
Search in titles only
Search in Visual Basic only
Search
Advanced Search
Forums
BYTES
Product Launch
Updates
Developer Toolkit
Today's Posts
Member List
Calendar
Home
Forum
Topic
Visual Basic
Displaying a worksheet in a userform
Collapse
X
Collapse
Posts
Latest Activity
Photos
Page
of
1
Filter
Time
All Time
Today
Last Week
Last Month
Show
All
Discussions only
Photos only
Videos only
Links only
Polls only
Events only
Filtered by:
Clear All
new posts
Previous
template
Next
fercontreras8
New Member
Join Date:
Jul 2007
Posts:
1
#1
Displaying a worksheet in a userform
Jul 12 '07, 09:38 PM
I am trying to create some sort of pop-up (probably a userform) in which I can display a worksheet. Is this possible?
Thank you.
kadghar
Recognized Expert
Top Contributor
Join Date:
Apr 2007
Posts:
1302
#2
Jul 12 '07, 10:54 PM
Originally posted by
fercontreras8
I am trying to create some sort of pop-up (probably a userform) in which I can display a worksheet. Is this possible?
Thank you.
yeap, go to the VB editor (alt f11) and add a user form...(called UserForm1 by defoult)
Add a Module and write a litte sub, something like:
sub OpenFrm()
UserForm1.show
end sub
and then add a command button on your worksheet (it's in the forms menu, you can add it) and asign the macro OpenFrm to your button...
that's the easiest way to call it, i guess.
Comment
Post
Cancel
Previous
template
Next
Working...
Yes
No
OK
OK
Cancel
👍
👎
☕
Comment