Dynamically link to control via module

Hi DelScorcho

Originally Posted by DelScorcho

Thanks, but I have tried that and I get the error: "Object doesn't support this property or method"

Yes. Course you did. That's 'cos I gave you the wrong code - I didn't read your post properly and thought you were using a userform. Fortunately, I know the right answer . Try this :

a = "ComboBox1"
Sheets("Worksheet1").OLEObjects(a).Object.AddItem "test"

HTH

DominicB