Trying to create a spreadsheet with drop menus

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

abrehm - 30 May 2008 00:17 GMT

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.

Signature

abrehm

Reply to this Message

Gord Dibben - 30 May 2008 00:26 GMT

Might be as easy as using Data>Validation>Allow>List.

Gord Dibben MS Excel MVP

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

Reply to this Message

Norman Jones - 30 May 2008 00:33 GMT

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

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

Reply to this Message