Hide/unhide specific cells based on the dropdown list value

S

Sam Kuo

Hi

I'd like to hide/unhide multiple cells when selecting a certain value in the
dropdown list. All cells are merged cells.

e.g. I have created a cell as a dropdown list containing "group A" and
"group B" using validation. I'd like to hide group B related cells when
"group A" is selected in the dropdown list; and vice-versa.

How can I do this? Any help would be appreciated.
 
T

Tom Ogilvy

Assumed you have named the cells with names to match those in the dropdown
list

for a Data Validation dropdown in Cell A1

Activesheet.Rows.Hidden = False
Range(Range("A1").Value).EntireRow.Hidden = True
 

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

Can this be done with HIDE - UNHIDE ? 4
Unhide/hide based on drop down list 0
drop down list for IF equation 8
Dropdown list of hyperlinks 3
Validation List 1
Activate / deactivate a link based on the value of a cell 0
HIDE-UNHIDE VBA MACRO 1
Finding the proper style field and the numbered paragraph value within the style 0

Top