Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide a column when value=1
Im tryng to do an interactive questionnaire, so that it would appear a
different list of questions depending on the previous answer. Therefore, Im trying to show only the right questions for the previous answers, hidding the rest of questions by hidding the column or the row in which they are placed. So, what do I have to do? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to hide a column when value=1
Hy!
You can use the following code to hide columns: If (value = 1) Then Worksheets("Sheet1").Range("B:C").EntireColumn.Hid den = True Else Worksheets("Sheet1").Range("B:C").EntireColumn.Hid den = False End If Regards Christian "angeloso" schrieb im Newsbeitrag ... Im tryng to do an interactive questionnaire, so that it would appear a different list of questions depending on the previous answer. Therefore, Im trying to show only the right questions for the previous answers, hidding the rest of questions by hidding the column or the row in which they are placed. So, what do I have to do? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hide Column | Excel Discussion (Misc queries) | |||
Hide Column If Usedrange of Column ISBLANK Follow-up | Excel Discussion (Misc queries) | |||
Hide Column If Usedrange of Column ISBLANK | Excel Discussion (Misc queries) | |||
UN-hide column A???? | Excel Discussion (Misc queries) | |||
Hide column or row based on a cell in the column or row? | Excel Discussion (Misc queries) |