+ Reply to Thread
Results 1 to 2 of 2

Starting a 'floating' form once a spreadsheet is open

  1. #1
    den1s
    Guest

    Starting a 'floating' form once a spreadsheet is open

    Hi,

    I have created a form which gives the user an option of selecting the
    source file for generating a spreadsheet. The form was created in
    Excel's VBA interface.

    Is there anyway I can get the form to automatically appear as soon as
    the excel spreadsheet is open? At the moment, the user needs to go into
    the VBA interface select the form and click 'run' before the form
    appears on the spreadsheet. I would like the form to simply appear as
    soon as the spreadhseet is open.

    - K


  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,482
    Private Sub Workbook_Open()
    UserForm1.Show
    End Sub
    this goes into a workbook module

    click on the xl icon beside the file menu
    choose view codes
    in the dropdown menu that reads general select workbook
    enter the above code that shows the userform
    if your userform is not called UserForm1
    then enter the name of the userform you want to show at startup

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1