Trying to create a spreadsheet with drop menus

  • Thread starter Thread starter abrehm
  • Start date Start date
A

abrehm

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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down Menus 2
is it possible for a drop down menu to select other drop down men 2
Restrict Choice in Shared WB (drop down alternative)? 0
Data Validation and a Clear Button 8
Getting Info From Drop Down Menu 3
macros to save then email 1
program drop down menus 1
Alt codes 4

Back
Top