Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down Lists
Hello,
I am trying to create drop down lists that will, when N/A is chosen as the option, it will hide/remove that section in my form. It will be done to shorten the amount of printing by reducing the number of cells at apply to that drop down list. I don't know if drop down lists are capable of doing this in Excel 2003/Word 2003 or if drop down list is the correct term for this type of action. Please Help. Brandon |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop Down Lists
Brandon
You're right that a Data Validation cell does not have that functionality. But there is a way. Use a Worksheet_Change macro. Something like this: Private Sub Worksheet_Change(ByVal Target As Range) If IsEmpty(Target.Value) Then Exit Sub If Intersect(Target, Range("F5")) Is Nothing Then Exit Sub If Target.Value = "N/A" Then _ Range("6:7").EntireRow.Hidden = True End If End Sub This macro will hide rows 6 and 7 if the value in F5 is "N/A". Is this what you want? This macro must be placed in the sheet module of the sheet in question. To access that module, right-click the sheet name, select View Code. Paste this macro into that module. HTH Otto "Brandon" wrote in message ... Hello, I am trying to create drop down lists that will, when N/A is chosen as the option, it will hide/remove that section in my form. It will be done to shorten the amount of printing by reducing the number of cells at apply to that drop down list. I don't know if drop down lists are capable of doing this in Excel 2003/Word 2003 or if drop down list is the correct term for this type of action. Please Help. Brandon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists from multiple source lists | Excel Worksheet Functions | |||
Drop Down Lists: Allow option of adding own data if not in drop do | Excel Worksheet Functions | |||
How to create 2 dependent drop down lists from 1 original drop dow | Excel Discussion (Misc queries) | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
Multiple lists with repeated values for dependet drop down lists | Excel Worksheet Functions |