Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to create a spreadsheet with drop menus
Do I need to know how to program using VB, C, or C+ in order to create a
spreadsheet that has drop down menus? I need to compile information to a sreadsheet from questaires that are received for later reference. -- abrehm |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to create a spreadsheet with drop menus
Might be as easy as using DataValidationAllowList.
Gord Dibben MS Excel MVP On Thu, 29 May 2008 16:17:00 -0700, abrehm wrote: Do I need to know how to program using VB, C, or C+ in order to create a spreadsheet that has drop down menus? I need to compile information to a sreadsheet from questaires that are received for later reference. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to create a spreadsheet with drop menus
Hi Abehm,
The answer depends on what you mean by dropdown menus; if you intend a dropdownlist in one or more worksheet cells, this functionality is natively available via Excel's Data Validation tool. If this is what you seek, Debra Dalgeish provides a superb tutorial at: Data Validation -- Introduction http://www.contextures.com/xlDataVal01.html If however you intend to customise Excel's menus, you would need to have a knowledge of VBA (Visual Basic for Applications) or to provide sufficient ancilliary detail to enable others to furnish the requisite code. --- Regards. Norman "abrehm" wrote in message ... Do I need to know how to program using VB, C, or C+ in order to create a spreadsheet that has drop down menus? I need to compile information to a sreadsheet from questaires that are received for later reference. -- abrehm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create travel template w/drop down menus | Excel Discussion (Misc queries) | |||
create 3 drop down menus in Excel, each relating to previous | Excel Worksheet Functions | |||
HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL? | Excel Worksheet Functions | |||
How do you create dual drop down menus in excel 2000? | Excel Discussion (Misc queries) | |||
Adding drop down menus to a spreadsheet | Excel Worksheet Functions |