Take a look at Data / Validation / List, which allow you to create a drop down list that the user
can select from. Debra Dalgleish has some nice examples at the following link:-

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL2K & XLXP

----------------------------------------------------------------------------
Attitude - A little thing that makes a BIG difference
----------------------------------------------------------------------------



"Burly" wrote in message ...
I want to be in a cell and let the user (pick from a list of amounts with a
click a mouse click in another cell) and then use that value in a formula in
the original cell. example $5. 00 $10.00 $15.00 $20.00 then subtract the
cost of the object to get the profit. I want ot start in the profit cell
and have a mouse click get the amount sold at 5,10,15,20.