Dynamically link to control via module

Hello,

I am trying to code to a combobox on a worksheet (Excel 2003) from a module using variables.

The following code gets me part of the way:

Please Login or Register  to view this content.

However I need to replace the name "combobox1" with a variable.




Thanks

Good morning DelScorcho

Originally Posted by DelScorcho

However I need to replace the name "combobox1" with a variable.

How about :

Please Login or Register  to view this content.

HTH

DominicB

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 :

Please Login or Register  to view this content.

HTH

DominicB