Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Selection
Hey guys
I have a listbox called ListBox1 and I want to make frame20.visible = true if any item in listbox1 is selected. How do I do this? Thanks Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Listbox Selection
Hi Todd
"How" is one side of it, "when" is another. Assuming that code or the user selects something/nothing in the list and you want it to happen immediately: Private Sub ListBox1_Click() Select Case ListBox1.ListIndex Case -1 Frame20.Visible = False Case Else Frame20.Visible = True End Select End Sub HTH. Best wishes Harald "Todd Huttenstine" skrev i melding ... Hey guys I have a listbox called ListBox1 and I want to make frame20.visible = true if any item in listbox1 is selected. How do I do this? Thanks Todd Huttenstine |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Listbox selection | Excel Discussion (Misc queries) | |||
Listbox & Selection | Excel Discussion (Misc queries) | |||
ListBox selection | Excel Programming | |||
Listbox multi selection | Excel Programming | |||
Run a macro when new selection in listbox | Excel Programming |