hiding rows with an if statement

L

Larry Fitch

I would like to be able to hide a number of rows based on the response to a
question..

The response to the question is a list box with either "yes" or "no" as the
choices.. If the response = "no" then I would like to hide the next 3 rows,
otherwise do nothing..

Is there a "hide" command of some sort that I can use as part of an IF
statement ?
 
P

Paul

Hi Larry,

You can't hide rows using a function, however you could do so using
worksheet_change macro if the "listbox" is actually a drop-down lis
using data validation.

If it is a listbox, you may be able to still do it, you'd just have t
specify which rows to hide since a listbox is not technically "in"
cell, but above the worksheet.



I would like to be able to hide a number of rows based on the respons
to a
 

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

Hiding Rows Using IF Statement 1
hisind rows with an if statement 1
Page numbering with Merged Document and IF statements 1
Hide columns based on row values 2
Populate a table based on check box status 2
Hide unused rows based on column info 5
If statement based on cell formatting/style 2
Auto-Hide Rows Macro 1

Top