Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Page 2 of 2 FirstFirst 12
Results 11 to 13 of 13

Thread: ListBox Docking

  1. #11
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dave,

    The code you wrote for the toggle button does not work. It will shrink the box the first time you click it, but will never let you expand it.
    Thanks in advance,
    Patrick

  2. #12
    Board Regular
    Join Date
    Mar 2002
    Posts
    103
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    i tried this code and it works for me. im using excel XP
    Will

  3. #13
    Board Regular
    Join Date
    Apr 2002
    Location
    Pittsburgh, PA
    Posts
    354
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    The only way I can get it to work is by doing the following:


    Private Sub ToggleButton1_Click()

    If ToggleButton1.Caption = "Expand" Then

    ToggleButton1.Caption = "Shrink"
    ExpenseErrors.Height = ExpenseErrors.Height * 4
    ToggleButton1 = False
    Else
    ToggleButton1.Caption = "Expand"
    ExpenseErrors.Height = 40

    End If

    End Sub
    Thanks in advance,
    Patrick

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
  •