Hiding Columns based on Drop Down list selection

**forge13** · 11-25-2011, 06:02 AM

Hi all

I would like to know if it is possible to implement a feature where by certain columns are hidden depending on what is selected from a drop-down list.

I'm presuming this may be achieved by the selected item affecting the custom views in some form? Also guessing it may take a Macro to get this going. I have installed and used macro's in the past but never written my own.....

any help appreciated!

**tom1977** · 11-25-2011, 06:13 AM

You can use such code:

Columns(Cells(1, 1).Value).Hidden = True

your drop list in A1 with values

and with this

Columns.Hidden = False

you will unhide all columns

**tom1977** · 11-25-2011, 06:15 AM

cancelled post

**forge13** · 11-25-2011, 06:22 AM

great, thanks for the tip. So do I put this in a macro or in the form itself?

**tom1977** · 11-25-2011, 06:27 AM

look at atachment

**forge13** · 11-25-2011, 06:39 AM

great. that should get me started I think. however, I think I may need to use it in conjunction with Data Filters than drop down lists. sorry, my fault for not being clear in my terminology usage