Access combobox controls in worksheet - Getting runtime error '438'

I have defined a global variable array in standard module. Defined 4 combo boxes in a worksheet (Sheet1) as Combobox1, Combobox 2 etc...

I am trying to access the combobox controls dynamically within a function in the worksheet (Sheet1) but I keep getting runtime error '438'. Object does not support property/method.

Can anyone suggest what am I missing?

Thanks in advance.

Please Login or Register  to view this content.

Hi Padala and welcome to ExcelForum,

Thank you for using Code Tags.

There are two types of controls on a SpreadSheet:
a. Forms Controls, and
b. Active X Controls

For a discussion of the difference between the two see: http://www.excelforum.com/excel-prog...ml#post3880991

You seem to have an 'Active X' control and are using Forms Control Syntax:

Typical 'Active X' Syntax (typically no spaces in the name):

Please Login or Register  to view this content.

Typical 'Forms Control Syntax (typically lots of spaces in the name:

Please Login or Register  to view this content.

I hope this helps.

Lewis

Thanks LJM.. That was it...