Excel 2000 Combo Box Control

[CarpalT]

I am trying to follow the example in Que's book "Using Excel 2000" to learn how to set up a combo box on a spreadsheet. After placing the control on the spreadsheet, you're supposed to right click, select "Format Object" and go to the "Control" Tab. The picture in the book shows Five tabs: Size, Protection, Properties, Web, and Control. My Excel 2000 9.0.4402 SR-1 has only four tabs, and the one I need is not there. Oh, great.
So I looked in the properties for the control, thinking I could find what I needed there. (Input Range, Cell Link, and Drop Down lines). They aren't there unless they have been renamed. Does anyone have an idea what might be going wrong here?
Thanks!

 

[combo]

Hi Giliam,
you can place two types of combo (and some other controls) on the sheet:
- from forms toolbar (existing still since ancient excel versions),
- from toolbox toolbar (ActiveX objects since xl 97, used on custom user forms) - this is your case.
Five format tabs are for the first one, four for the second.

If you want to work with ActiveX combo:
To link cell/list to combo, click 'properties' from the popup menu, find 'LinkedCell' and 'ListFillRange' properties.
To make control working, deselect 'design mode' button on the toolbox toolbar (left top, triangle icon).
If you need to change control, switch on the design mode first (button on toolbox toolbar).