PDA

View Full Version : Solved: hide/unhide rows based on value of target cell



K. Georgiadis
10-13-2007, 01:52 PM
I used the search engine but most results were either partly relevant or too complicated.

What I am trying to accomplish is a simple toggle switch:


I use an Excel combo box with linked cell M2
The value of cell M2 is either 1 or 2
When the value of M2 = 1, I want to display Row 10 & hide Row 11
When the value of M2 = 2, I want to hide Row 10 & display Row 11Can you point me to the syntax for a simple task such as the above?

Many thanks!

lucas
10-13-2007, 04:38 PM
Hi K,
Try this...I used a combobox from the forms toolbar and assigned it to the macro..hope I got the order correct.

K. Georgiadis
10-13-2007, 06:10 PM
This is working great Lucas. Thank you very much :beerchug: I am marking "Solved."