The comboboxes from the control toolbox toolbar work differently.

First, click the Design Mode icon on that same control toolbox toolbar. Then
rightclick on the combobox. Choose properties.

You'll see lots more options that you can set here--including:
LinkedCell
ListFillRange
And Style (allow typing or just pick from list)

Notice that the linked cell doesn't return an index into that list--it actually
returns the value in the combobox.

=====
And you still may want to look at Data|validation. This is usually easier to
use then either the dropdown or combobox.

Take a look at Debra Dalgleish's site:
http://contextures.com/xlDataVal01.html

She has lots of tips and hints there.

hays4 wrote:

Hi Dave,
yes you're right, I had created the combo box where the "move and size
with cells" option is greyed out.
So I created another combo box the other way, but when I choose Format
Control there's no control tab to specify all my options etc. So how do
these kind of combo boxes work?
Hayley

--
hays4
------------------------------------------------------------------------
hays4's Profile: http://www.excelforum.com/member.php...o&userid=28069
View this thread: http://www.excelforum.com/showthread...hreadid=482783

--

Dave Peterson