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:

Please Login or Register  to view this content.

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

Welcome to the Forum, please read the Forum Rules & use Code Tags in future, select the code & use the # button

If the code is in the correct place, i.e. the sheet module then the use of Me is correct.
There is a LinkedCell Property, but you can use the code

Please Login or Register  to view this content.

Have you loaded values uno the ComboBox? Attach the workbook with the combobox & code

Option Explicit needs to be at the top of the module.

Your code is working, but the combobox is over the top of B2, you can't see the result. I put B1 but it should have been B2. This is correct

Please Login or Register  to view this content.

No problem, please mark the thread solved & maybe rate the answer

You need to use the Edit button on your first post, then click Go Advanced and you will see a drop down next to the title which allows you to add Solved to the title.