ListBox Docking

[poleary2000]

I have a UserForm that I would like to user to see at all times. Is there anyway to write some code that will make the UserForm Dockable?? Meaning, it attaches itself to Excel [kind of like the Locals window in the VBA editor].

Any help would be appreciated.

 

[poleary2000]

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.

 

[willlobb]

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

 

[poleary2000]

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