You should consider using the equivalent control from the Controls
toolbar i.e. the ActiveX ComboBox control. These controls are
notoriously buggy when used on a worksheet, and rightly so in most
cases, but I've used them extensively and I've never had a problem
with the ComboBox control. The big advantage of using an ActiveX
control is that you can declare one as a WithEvents object variable in
a class module and trap its events. This means that multiple ComboBox
controls can have a common event handler which could test the name of
the ComboBox for that particular instance of the class.

"Darren Hill" wrote in message ...
Oops - forgot to mention I'm using Excel2000 on WinXP.
--
Darren

"Darren Hill" wrote in message
...
I'm not sure how to manipulate the DropDown boxes from the Forms toolbar.
Here's my problem:

I have a set of dropdowns in cells A5:A20.
I have second set of dropdowns in cells B5:B20.

When a selection is made in the Set A dropdowns, I want to change the
listfillrange displayed in the adjacent dropdown in Set B.

I could create a macro linked to each of the dropdowns in column A, but
I'm
sure there's a way to have a single macro, and in that macro identify
which
row I'm on, and then select the dropdown in column B on the same row.

Thanks in Advance.

Darren