Hide column based on data validation

S

shahbaz01

Joined
Nov 27, 2012
Messages
1
Reaction score
0
Hi Excel pros,

How could I hide a column based on a data validation list?
I applied the instructions in a 2004 post of this forum titled 'Hide Columns based on a Data Validation List', but couldn't figure it out.

I'd like to display column H if "Scolaire" or "Service Spécial" is selected at least once in the data validation list of the column N.

Private Sub Worksheet_Change(ByVal Target As Range)

Select Case Target.Value
Case "Ligne"
Columns("I:J").Hidden = True
Case "Scolaire"
Columns("I:J").Hidden = False
Case "Service Spécial"
ActiveSheet.Columns("I:J").EntireColumn.Hidden = False
Case "Occasionnel"
ActiveSheet.Columns("I:J").EntireColumn.Hidden = True
End Select

End Sub

Thanks for your help.
Shahbaz
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

2 validation macros 2
Hide Columns Based On Date Value 1
Excel Target.column for Data Validation would like to target some cells within column 1
UserForm ListBox 1
VBA Check Spelling doesn't highlight misspelled word 5
hide colum based on cell value on each worksheets 2
Trying to hide all rows where no data is in columns AQ-AV 2
hide multiple worksheets based on a formula value in one cell 1

Top