Hi oam,

snb's code should work. I think you may not be aware of the worksheet's CodeName property. Select the worksheet that has the combobox. Right-click the tab and select view code. You are now looking at that worksheet's object module. Presumably you should have the Properties window displayed. In it, you will notice two Name properties, one (at the top) that has parenthesis surrounding it like "(Name)". This is the CodeName and the one we care about. Use whatever is there in place of 'Sheet1' in snb's first example.

How's that work?

Mark