Is there a way to toggle the display of a ListBox?

"Phil H." wrote in message
...
Is there a way to toggle the display of a ListBox?

Sure. What kind of toggle did you have in mind ?

Best wishes Harald

Harold, Thanks for the encouraging response.

I've created ListBox1, put it in the header row of a spreadsheet, and want
to toggle the display of the ListBox on and off. I have numerous columns and
don't have room for a permanent display, so toggling is my answer. Toggled
on, the user can scroll down the list to find information; toggled off, the
ListBox disappears and only the toggle button remains visable.

Phil

"Harald Staff" wrote:

"Phil H." wrote in message
...
Is there a way to toggle the display of a ListBox?

Sure. What kind of toggle did you have in mind ?

Best wishes Harald

Hi Phil

Toggle button code (rightclick; "view code", or similar):

Private Sub ToggleButton1_Click()
Me.ListBox1.Visible = Me.ToggleButton1.Value
'or
'Me.ListBox1.Visible = Not (Me.ToggleButton1.Value)
End Sub

Best wishes Harald


"Phil H." wrote in message
...
Harold, Thanks for the encouraging response.

I've created ListBox1, put it in the header row of a spreadsheet, and want
to toggle the display of the ListBox on and off. I have numerous columns
and
don't have room for a permanent display, so toggling is my answer.
Toggled
on, the user can scroll down the list to find information; toggled off,
the
ListBox disappears and only the toggle button remains visable.

Phil

"Harald Staff" wrote:

"Phil H." wrote in message
...
Is there a way to toggle the display of a ListBox?

Sure. What kind of toggle did you have in mind ?

Best wishes Harald

Thanks, Harald - works exactly as needed.

"Harald Staff" wrote:

Hi Phil

Toggle button code (rightclick; "view code", or similar):

Private Sub ToggleButton1_Click()
Me.ListBox1.Visible = Me.ToggleButton1.Value
'or
'Me.ListBox1.Visible = Not (Me.ToggleButton1.Value)
End Sub

Best wishes Harald


"Phil H." wrote in message
...
Harold, Thanks for the encouraging response.

I've created ListBox1, put it in the header row of a spreadsheet, and want
to toggle the display of the ListBox on and off. I have numerous columns
and
don't have room for a permanent display, so toggling is my answer.
Toggled
on, the user can scroll down the list to find information; toggled off,
the
ListBox disappears and only the toggle button remains visable.

Phil

"Harald Staff" wrote:

"Phil H." wrote in message
...
Is there a way to toggle the display of a ListBox?

Sure. What kind of toggle did you have in mind ?

Best wishes Harald