Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/unhide specific cells based on the dropdown list value
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide/unhide specific cells based on the dropdown list value
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 -- Regards, Tom Ogilvy "Sam Kuo" .(donotspam) wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to hide/unhide WS based upon WS tab color | Excel Discussion (Misc queries) | |||
Hide or unhide sheets based on cell | Excel Discussion (Misc queries) | |||
Hide or Unhide Column Based on Cell Value | Excel Programming | |||
Hide/Unhide column based on cell value | Excel Programming | |||
Hide colums based on dropdown list | Excel Programming |