I have a number of worksheets with combobox lists in them.
What I want to do is populate the comboboxes with items
listed in named ranges on a master worksheet but am not
sure how I would loop through each combobox on each
worksheet.

The code for populating I already have. I need to look at
each combobox on each sheet and if combobox is cbOne then
populate with items from list1, cb2 - list2 etc.

Something along the lines of:-

Dim sht as worksheet, cb as comboBox

For each sht in ActiveWorkbook
For each cb in sht.Controls 'controls collection
_ 'will not work here
'add list items
Next
Next


Can anyone help ??

regards,

TonyM