Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
show/hide rows with listbox
Hi,
Depending on the choice a user makes in a listbox, I would like to show some rows with information. Has any of you an idea how to do this? I succeeded do to this for a checkbox, but with a listbox I come not even close. Thanks, steven |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
show/hide rows with listbox
Private Sub Listbox1_Click()
rows("1:150").Hidden = False Select Case Listbox1.ListIndex Case 0 rows("2:3").Hidden = True case 1 rows(99:105").Hidden = True case 2 rows("50:55").Hiddent = True End Select End Sub -- Regards, Tom Ogilvy "sharkje76" wrote in message lkaboutsoftware.com... Hi, Depending on the choice a user makes in a listbox, I would like to show some rows with information. Has any of you an idea how to do this? I succeeded do to this for a checkbox, but with a listbox I come not even close. Thanks, steven |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Rows - copy and paste only rows that show | Excel Worksheet Functions | |||
Hide rows but show when printing | Excel Discussion (Misc queries) | |||
Showing + and - (show and hide) for rows in the sheet | Excel Worksheet Functions | |||
Hide and show Rows | Excel Discussion (Misc queries) | |||
Checkbox to hide or show rows | Excel Programming |