Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 8 of 8

Thread: MultiPage

  1. #1
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello
    Does anyone know how I would disable a page in a multipage?

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Or does anyone know how to simply refer to a page in a multipage?

  3. #3
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try

    MultiPage.Value

    -rh

  4. #4
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-11 13:45, waggy30 wrote:
    Hello
    Does anyone know how I would disable a page in a multipage?
    You can hide a page if you like:

    MultiPage1.Pages(1).Visible = False

    Would hide the second page (multipage pages are zero-based).

    Hope this helps,

    Russell

  5. #5
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sorry didn't explain myself properly. What i want is to refer to the enabled property of a page in a multipage. I've tried

    multipage1.page1.enabled = False

    but it doesn't work. Any ideas?

  6. #6
    New Member
    Join Date
    Mar 2002
    Location
    England
    Posts
    46
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Russel i used your code, and used it in mine

    Private Sub UserForm_Initialize()
    If Range("route") = "1" Then
    MultiPage1.Pages(0).Visible = False
    Else
    MultiPage1.Pages(1).Visible = False
    End If
    End Sub

    And i get run-time errors. Any idea why?

  7. #7
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-11 14:26, waggy30 wrote:
    Russel i used your code, and used it in mine

    Private Sub UserForm_Initialize()
    If Range("route") = "1" Then
    MultiPage1.Pages(0).Visible = False
    Else
    MultiPage1.Pages(1).Visible = False
    End If
    End Sub

    And i get run-time errors. Any idea why?
    It could be in your "Range" reference. You need to precede it with the sheet. For example,

    Sheets("Sheet1").Range("route")

    Hope this helps,

    Russell

    [ This Message was edited by: Russell Hauf on 2002-03-11 17:43 ]

  8. #8
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-11 14:26, waggy30 wrote:
    Russel i used your code, and used it in mine

    Private Sub UserForm_Initialize()
    If Range("route") = "1" Then
    MultiPage1.Pages(0).Visible = False
    Else
    MultiPage1.Pages(1).Visible = False
    End If
    End Sub

    And i get run-time errors. Any idea why?
    What is the exact error and where is it happening (hit debug when you get the error to find out)?

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
  •