Hiding Rows, referencing a Linked Cell From A Combo Box

Hi cadk73,

Your example doesn't include the dropdown code.

Sub Dropdown1_Change(DDChoice As Integer)

With ActiveSheet

Select Case DDChoice
Case 1
.Rows("14:29").Hidden = True

Case 2
.Rows("14:17").Hidden = False
.Rows("18:29").Hidden = True

Case 3
.Rows("14:21").Hidden = False
.Rows("22:29").Hidden = True

Case 4
.Rows("14:25").Hidden = False
.Rows("26:29").Hidden = True

Case 5
.Rows("14:29").Hidden = False
End Select
End With
End Sub

Sub TestDDC()
Dropdown1_Change (5)

End Sub

But this code, properly placed, seems to do the trick.

Hi cadk73,

Where is your code? The argument not optional means that the macro has to be called like:

Dropdown1_Change(1 thru 5 here - this is the argument)

Hi cadk73,

Here's a copy of your book with the code which seems to be working!

Copy of Example.xlsm

I had all but forgotten how to code the standard controls, disregard most of my earlier comments - sorry!

Great - Glad it worked!