Excel..condition based on drop down list Closed

Question

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..

venkat1926 · Answer

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

Excel..condition based on drop down list

1 response

Similar discussions

Subscribe To Our Newsletter!