Excel..condition based on drop down list

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I've created a drop list (using the validation method). in excel 2003.

What I wish to do...

is create a condition where another cell is invisible unless a specific option from the drop list is selected... the drop list has option list words not numerics..

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
try these two macros
s is in the list of validation
one problem is will you remember which cell is hidden so that you can unhide it.

Sub hide_cell() 
If Selection.Value = "s" Then 
Selection.NumberFormat = ";;;" 

End If 
End Sub



Sub unhide_cell() 
Selection.NumberFormat = "general" 
End Sub
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month