Results 1 to 7 of 7

Thread: UserForm (2002)

  1. #1
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    UserForm (2002)

    I created a userform, but for the life of me I can't remember how to call the worksheet I want with the option buttons. IF "basic" is true then custom view "basic", if "advance" then custom view "advance", if "intermediate" then custom view intermediate. The spreadsheet is set up for custom viewing ( This piece of the puzzle I did not create, but was given the direction to utilizing this sheet because once the form is set. They would like to be able to update the "custom view spreadsheet"). Can anyone provide direction?

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: UserForm (2002)

    something like this perhaps?

    if Basic then
    ActiveWorkbook.CustomViews("basic").Show
    elseif Advance then
    ActiveWorkbook.CustomViews("Advance").Show
    else
    ActiveWorkbook.CustomViews("intermediate").Show
    endif

    Steve

  3. #3
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UserForm (2002)

    Thanks for getting back to me. Question, the views are on a seperate sheet called "oe", do I need to call the worksheet instead of ActiveWorkbook? I receive an error message when I use ActiveWorkbook.CustomViews("basic").Show . Thanks again for getting back to me.

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UserForm (2002)

    Worksheets don't have custom views, only workbooks. What error message are you getting?
    Legare Coleman

  5. #5
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UserForm (2002)

    Sorry! The error was on my end. It's working. Now, I need to figure out.. Once I'm in my view. I would like to return to the blank sheet entitled "Training" with my useform in view.. My "Cancel" button currently unloads the form but I would like to return to "Training".. When I open the workbook, the userform is displayed. I would like to click Cancel & return to where I opend the workbook. Thanks :-)

  6. #6
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UserForm (2002)

    Does:

    WorkSheets("Training").Activate

    do what you want?
    Legare Coleman

  7. #7
    Star Lounger
    Join Date
    Jul 2005
    Location
    Earth, New Jersey, USA
    Posts
    53
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: UserForm (2002)

    Legare.. Thank you so much!

Posting Permissions

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