View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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