Its just dawned on me that the Combo Box is floating and is not relevant to a
particular cell which is clearly why I cannot get the calculations to work.

I guess my next question is, "Is it possible to link Combo Boxes to a
particular cell ?"

Many thanks



"Mike H" wrote:

Hi,

You may have seen a combo-box.

View|Toolbars|Forms

From the forms toolbar put a combo-box on you wrksheet.

Mike


"dave caizley" wrote:

In my XL2003 workbooks, I have a number of drop down lists. The small
indicator to the right only appears when I click on a cell with a list in it.

I have seen spreadsheets where every list is permanently identifiable as the
indicator is permanently visible.

How is this done please

Thanks in anticipation