| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hide colums based on dropdown list
I like to be able to hide/unhide colums based on a dropdown lis
selection The 1st column starts in K and the 7th column in Q If dropdown selection = 1, then hide columns L to Q, show columns If dropdown selection = 2, then hide columns M to Q, show columns K- Etc til If dropdown selection = 2, then show columns K to Is there a way to do this in VBA. I've been trying to do this bu without any success Any help is appreciated Michae -------- Message sent via www.excelforums.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a dropdown list based on selection from a differernt drop | Excel Discussion (Misc queries) | |||
| Drop down list based on choice of another dropdown | Excel Discussion (Misc queries) | |||
| Get matching values and formulas from ajoining colums of dropdown | Excel Discussion (Misc queries) | |||
| offer dropdown options based on another dropdown | Excel Discussion (Misc queries) | |||
| Hide Columns based on a Data Validation List | Excel Programming | |||
Threaded Mode
