Ok, that is exactly what I am looking for...HOWEVER!!

I used the combo box and set the Input Range based on a range of %'s (from
1.0% to 5% over 5 cells). No problem there as the box shows the percent.
However, the Cell Link shows a number and NOT what is in the combo box. It
puts in 1, 2, 3, 4 or 5 which is the line that the % in the box correlates
with. To summarize, the Cell Link is not showing what is in the combo box.
I know I'm just missing something stupid.

"Carole O" wrote:

Jim -

You'll have to change from a list to a combo or list box (Toolbar - Forms)

Carole O

"DiamondJim" wrote:

In Excel - created drop down list...no problem. However, how do I set the
work sheet so that the drop down button always shows rather than now where it
disappears then I click on another cell.