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

L

Louise Scott

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???
 
D

Doug

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
 
Top