Displaying a worksheet in a userform

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • fercontreras8
    New Member
    • Jul 2007
    • 1

    Displaying a worksheet in a userform

    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
    • Apr 2007
    • 1302

    #2
    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

    Working...