Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
BACKGROUND:
I am trying to create a drop down box that will give the user an option to select a year. From that year selected, I will then use the output with the OFFSET formula to go grab data from another tab. QUESTIONS: 1.For a drop down menu, when should I use the Forms toolbar options vs. when do I use the Control Toolbox options vs. when should I use Data Validation to create my drop down menu? 2.In general, when would I use the Forms toolbar and when should I be using the Control Toolbox? They seem similar. Thanks in advance for your help. -Scott |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Data Validation Window? | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) | |||
Excel2K: Is it possible to use dynamic named ranges in custom data validation formula? | Excel Discussion (Misc queries) |