how do i set up drop down menus to populate cells in excel?
 

Hi,

I'm trying to build a database in excel, and to aide data inputting, i'm
trying to figure out if you can use drop down menu's like in the form view of
access. eg in access you list all the possble responses and add this to the
drop down menu for selection to populate the field so you don't have to type
it out again. I'm using excel because several people will need access to the
file and not many use access. Is it possible to do this in excel???

You can use Data Validation to create dropdown lists. There are
instructions in Excel's help, and he

http://www.contextures.com/xlDataVal01.html


Louise Scott wrote:
Hi,

I'm trying to build a database in excel, and to aide data inputting, i'm
trying to figure out if you can use drop down menu's like in the form view of
access. eg in access you list all the possble responses and add this to the
drop down menu for selection to populate the field so you don't have to type
it out again. I'm using excel because several people will need access to the
file and not many use access. Is it possible to do this in excel???


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Hi

This is for a dropdown control. If H1 is your link cell and E5 is the cell
where your list of dropdown value starts. Assign this macro to the control
by right clicking on the dropdown control.

Sub aaa()
ActiveCell.Value = [E5].Offset([H1].Value-1, 0).Value
End Sub



Louise Scott wrote in message
...
Hi,

I'm trying to build a database in excel, and to aide data inputting, i'm
trying to figure out if you can use drop down menu's like in the form view
of
access. eg in access you list all the possble responses and add this to the
drop down menu for selection to populate the field so you don't have to
type
it out again. I'm using excel because several people will need access to
the
file and not many use access. Is it possible to do this in excel???