Excel..condition based on drop down list

Closed
Kingleviathan - Sep 25, 2010 at 08:30 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 25, 2010 at 09:04 PM
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

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 25, 2010 at 09:04 PM
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