Results 1 to 2 of 2

Thread: How can I start up a specific form while I open an Excel File?

  1. Jun 23rd, 2000, 05:51 PM #1
    lt_lam
    lt_lam is offline

    Thread Starter
    New Member
    Join Date
    Jun 2000
    Posts
    1

    Unhappy

    Hello Everybody,,

    I have designed a form in an excel file.
    Now I would like to set the form as an startup
    object. But How ????

    Pls Help.

    gAry Lam
    Reply With Quote Reply With Quote
  2. Jun 23rd, 2000, 06:35 PM #2
    R@emdonck
    R@emdonck is offline
    Lively Member
    Join Date
    Nov 1999
    Location
    Belgium
    Posts
    98
    Hi,

    You can use:

    Private Sub Workbook_Open()

    Load Userform1
    Userform1.Show

    End Sub

    Bye ...
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width