mercredi 6 juillet 2016

VBA Excel Double If

I have various dropdown menus in the document and need to create a double conditional statement.

So I am trying to do the following:

If Cell B14 = Option 1 Then unhide Cells B16:B17 If Cells B17 = Yes Then hide Cells B19:B53 If Cells B17 = No Then show Cells B19:B34

So if someone picks Option 1 from the dropdown menu then there is another drop down menu that appear and if they select Yes from the second on it hide the required cells and if they pick No it unhides the required cells.

Options 2 & 3 in the first dropdown menu do not need to show the second drop down box.

I have it all working apart from the double if.

Aucun commentaire:

Enregistrer un commentaire