drop-down menu

  • Thread starter Thread starter Luc
  • Start date Start date
L

Luc

Hi all, I'm trying to make a drop-down box, to limit the
choices available to a user. I want to put 12 mths in the
drop down menu and once it's selected have a formula
calculate something based on the selection. Hope that
makes sense and someone can help. Thanks, Luc
 
Create a list of months somewhere away from your workings, let's say a1:a12
though for this.

Highlight a cell where you want the drop down menu, then go to Data, then
Validation, and under "Allow" with the "Validation Criteria" tab select
"List". This will then allow you to specify the range for this list, which
is a1:a12.

You can copy and paste this validation drop-down menu into other cells.


Mike
 
Fantastic! that worked a treat. Thanks a lot.

-----Original Message-----
Create a list of months somewhere away from your workings, let's say a1:a12
though for this.

Highlight a cell where you want the drop down menu, then go to Data, then
Validation, and under "Allow" with the "Validation Criteria" tab select
"List". This will then allow you to specify the range for this list, which
is a1:a12.

You can copy and paste this validation drop-down menu into other cells.


Mike





.
Click to expand...
 
Back
Top