Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Userform focus question

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way that I can have my userform display before the file is opened?

    I have a userform that will show the user the information they will be wanting to see. I would like for when the file is opened just the userform displays with the information, I have a button for the user to click if they want to add or view the information and another button that will close the file if the userforms data was all they needed to see.

    My boss keeps telling me to just keep the files simple but I like all the extras.

    Simple never impressed anyone.

    Thanks,



    I appreciate the help from everyone at Mr. Excel.

    viper

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Huntington Beach, CA USA
    Posts
    327
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Simply "NO", but you could set the size of the UserForm to fill the whole screen.

    Do you already have it set up as:

    Private Sub Workbook_Open()
    UserForm1.Show

    James


    _________________


    [ This Message was edited by: James on 2002-05-05 16:17 ]

    [ This Message was edited by: James on 2002-05-05 16:19 ]

  3. #3
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    how about having worksheets hidden on closeing.
    Then have the form run on opening the workbook.
    Then if the user selects the command button to see the worksheets you just unhide them ?

  4. #4
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Not really.

    You'd need a WorkBook_BeforeOpen event, which doesn't exist.

    One suggestion I'd have is to maybe mess around with a full screen userform, or a userform that fills the whole of the spreadsheet area. So long as you make it modal, there's not much the user can do about it.

  5. #5
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-05 16:14, Nimrod wrote:
    how about having worksheets hidden on closeing.
    Then have the form run on opening the workbook.
    Then if the user selects the command button to see the worksheets you just unhide them ?
    Dammit! You guys are too fast.

    One comment on Nimrod's post though. There has to be at least one worksheet visible at all times, so hiding all of the sheets isn't an option.

  6. #6
    MrExcel MVP
    Join Date
    Apr 2002
    Location
    Vancouver BC , Canada
    Posts
    6,259
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    It seems that you have to have at least one sheet visiable. But maybe you could minimize the workbook on opening and then Max it only if required. This may give you the "effect" your looking for.

  7. #7
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks for all the suggestions. I'll try them and see which one works best.

    Thanks again,
    I appreciate the help from everyone at Mr. Excel.

    viper

  8. #8
    Board Regular
    Join Date
    Mar 2002
    Location
    Phoenix, Arizona
    Posts
    529
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Nimrod - Wouldn't a minimized Workbook hide the UserForm also? I'd also like to be able to have a UserForm be the first thing the user sees when opening the Workbook, but I'm not following what you mean by minimizing the Workbook to accomplish this.

  9. #9
    Wizard Deluxe
    Join Date
    Jun 2002
    Posts
    348
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hey Viper,

    I have an Excel file with a Splash page. There is one visible sheet but it is filled black, and no data what so ever. OnOpen the Splash runs; when the timer is up and it comes time to Unload ( in a module) I put the sheets.visible code in like this:

    _____________________________________

    Private Sub KillTheForm()
    Unload Splash1
    Sheets("Sheet1").Visible = True
    Sheets("Sheet2").Visible = True
    Sheets("Sheet3").Visible = True
    End Sub
    ______________________________________

    This works just fine for me. When the Splash unloads the sheets are now visible.

    Regards,

    ViperGTS

    [ This Message was edited by: ViperGTS on 2002-09-25 19:33 ]

  10. #10
    Board Regular
    Join Date
    Feb 2002
    Location
    Jefferson City, Missouri
    Posts
    382
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks gts,

    It's been so long since I posted this that I can't remember which workbook I used this on.

    RogerC,

    to minimize your open workbook put this code into the workbook_open sub

    Activewindow.windowstate = xlMinimized
    Userform1.show

    Upon opening of your workbook it will minimize the workbook and then display your userform. You will then need to add
    activewindow.windowstate = xlMaximized at the end of a timer or in the click_event of a command button to show your workbook.

    HTH

    Thanks again G,
    viper

    _________________
    I appreciate the help from everyone at Mr. Excel.

    viper

    [ This Message was edited by: viper on 2002-09-25 20:52 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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