Drop down list for excel97
Colin,
Perhaps a simple Data Validation dropdown list might serve your
purpose. You will need a list of names say in A1:A9 Then select a
cell or range of cells where you want to use the list. Then on Menu
go to Data>Validation Select "list" from Allow box. Enter your range
A1:A9 and go from there. When a user selects the cell or a cell in
the range you picked, they will get a dropdown list of the names.
HTH Gord
On Thu, 03 Feb 2000 21:36:19 GMT, "Colin Mawdsley"
Quote:
>I am basicly new to VBA except for the fact that I have done a few control
>buttons using macros of my regular movements in a spreadsheet. I would like
>to have a drop down box that will do the following:
> 1 Select a cell
> 2 Go to drop down list
> 3 Select a name from the list
> 4 Name will enter into the selected cell
>I had this set up once in excel version 5, but I can't get it to work in
>excel 97.
>Can anyone help me with what the macro could be...?
>TIA
>Colin Mawdsley