show/hide rows with listbox

  • Thread starter Thread starter sharkje76
  • Start date Start date
S

sharkje76

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Listbox Problem 1
using variables in listbox 9
Access Cannot select items in listbox 1
listbox click event question 4
Show Last Record in the Listbox when userform Loads. 8
Listbox with Check Box Option?? 3
Array by getrows to listbox - date format problem 0
UserForm ListBox w/ Multiple Checkboxes 1

Back
Top