missing 'control' tab in combo box

[jammoca]

The old excel versions used to have a tab called 'control' in the format control section of a combo box. My excel 2000 version seems to miss this tab. How am i meant to set the INPUT RANGE, CELL LINK and DROP-DOWN LINES without this facility ?? I have no ability with VBA so relied on this heavily. I've been making do by copy/pasting an old version of a combo box into my new documents 'cause they of course have the control tab. Any ideas???????

 

[Andrew Poulsom]

Activate the Control Toolbox and click the Design icon (top right). Right click your combo box and choose Properties. The ones you are looking for are ListFillRange, LinkedCell and ListRows. After changing these properties, close the Properties window and click the Design icon again to exit design mode.