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.
|