Hide Rows

  • Thread starter Thread starter courtesio99
  • Start date Start date
C

courtesio99

Can anyone help me with the following problem?

I have a drop down list, e.g. with 4 options.
each option is represented by a row of data, and each cell in each row
is to be entered by the user. (That means I have 4 rows of data.)

How do I unhide a certain row that is selected via the drop down list
whilst hiding the rest of the 3 rows?
 
At first ,u must lock the size and location of the listbox1,then add the
code to the model:

Private Sub ListBox1_Change()
For i = 0 To ListBox1.ListCount - 1
Rows(i + 1).Hidden = ListBox1.Selected(i)
Next
End Sub


courtesio99 said:
Can anyone help me with the following problem?

I have a drop down list, e.g. with 4 options.
each option is represented by a row of data, and each cell in each row
is to be entered by the user. (That means I have 4 rows of data.)

How do I unhide a certain row that is selected via the drop down list
whilst hiding the rest of the 3 rows?


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Use Data > Filter > Autofilter

courtesio99 said:
Can anyone help me with the following problem?

I have a drop down list, e.g. with 4 options.
each option is represented by a row of data, and each cell in each row
is to be entered by the user. (That means I have 4 rows of data.)

How do I unhide a certain row that is selected via the drop down list
whilst hiding the rest of the 3 rows?


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top