Hiding/Showing Rows With Combobox

Hi,

I am trying to hide/show a static set of rows based on the value chosen within a combobox.

The combobox has a list of names and one blank. The blank is selected by default, which renders the rows hidden. When a user selects a name in the combobox the rows will be shown.

I got some help on this, which allowed me to hide the rows when the workbook was activated and when the worksheet was activated, but the code to show/hide the rows based on the combobox value is not working.

It is:

Private Sub CBO_Person_Click()
If Me.CBO_Person.ListIndex <> -1 Then
    Me.Rows("6:29").EntireRow.Hidden = _
        (Me.CBO_Person.ListIndex < 1)
End If
End Sub

I keep getting Compile Error: Invalid use of ME keyword.

Any ideas?

This is using a control toolbox combobox and not a form toolbox combobox. If possible, I'd prefer to use the form toolbox combobox as I want to use its Cell Link property to populate a cell with the index of the value chosen for further formulas to work with.

Thanks!
Cray