drop-down menu

[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

 

[Mike]

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

 

[Luc]

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





.