Hey Gord,

Thanks for the reply.

When I first wrote my code, I tried to use the Toolbox ComboBox but
could not find the RowSource property so went with the Forms ComboBox.
Like you said it does not have as many properties. But one property
that it does have is the Link Cell property, which returns the row
number of the item chosen. This is very handy.

The Toolbox ComboBox does not have a RowSource property, but I
discovered today that it has a ListFillRange property which does
almost the same thing.

As for the Forms ComboBox properties, under the Format ControlControl
there are two drop downs, one for Input Range (Row Source) and one for
Cell Link (which returns the row number of the chosen item in the
Input Range).

The Toolbox ComboBox also has a LinkCell property but all it does is
show what is in the chosen cell, not which row it is.

Although the Toolbox ComboBox has more properties the Forms ComboBox,
the Forms ComboBox has that Cell link that I was able to use.

All of the other cell formulas are Offsets based on that row number in
the linked cell. I am trying to get away from VLOOKUP's.

If I could figure out how to get the row number of the chosen item, I
would gladly switch from the Forms ComboBox to the Toolbox ComboBox.

Any ideas? Would it help if I posted my code?

-Minitman



On Tue, 01 Jul 2008 16:07:19 -0700, Gord Dibben <gorddibbATshawDOTca
wrote:

The combobox from ViewToolbarsControl Toolbox is same one as Toolbox in VBE.

This type of combobox is much more customizable and versatile than the one from
the Forms Toolbar.

Draw one of each on your sheet to see the difference when you right-click.

With Toolbox combobox right-click and "Properties" will give a host of options
not found on the Forms combobox.


Gord Dibben MS Excel MVP

On Tue, 01 Jul 2008 17:44:03 -0500, Minitman
wrote:

Greetings,

I noticed that there are three different ComboBoxes available.

The one in the Visual Basic Editor, the one in ViewToolbarsControl
Toolbox and the one in ViewToolbarsForms.

I was wondering if anyone could tell me what are the pros and cons of
each type?

I would really appreciate any comments on this question.

-Minitman