Form Controls on Worksheet

[H.G. Lamy]

Hello,

can I use an array as input range for a combo box (I mean form controls, not
ActiveX controls) ?

Kind regards,

H.G. Lamy

 

[Rick Rothstein]

Can you expand your description for us? Are you asking about doing this in
VB code? When you say "array", do you mean a range of cells or an actual VB
array? If the latter, what data type (Variant, String, etc.) is the array
declared as? And I'm assuming from your brief description that your ComboBox
is on a worksheet and not a UserForm, right?

 

[H.G. Lamy]

Rick, thanks,

as you know, there are 2 types of controls available in Excel:

1. good old simple Form controls, and 2. ActiveX controls.

Both types can principally be used on worksheets, but ActiveX controls are
more suited for UserForms, and are less reliable when applied on worksheets
directly.

On my worksheet I need to use the simple combo box (or drop down) from the
forms collection. (The combo box serves to have the user pick one of 12
months).

To make the control work, an "input range", and a "cell link" have to be
assigned - both usually as classic range-addresses on a worksheet.

Because of varying worksheets, I try to replace these 2 range-addresses by a
either defined name, or a constant, or an array, or anything else so as to
avoid range-addresses.

Any idea ?

Kind regards,

H.G. Lamy

 

[H.G. Lamy]

Rick, thanks,

as you know, there are 2 types of controls available in Excel:

1. good old simple Form controls, and 2. ActiveX controls.

Both types can principally be used on worksheets, but ActiveX controls are
more suited for UserForms, and are less reliable when applied on worksheets
directly.

On my worksheet I need to use the simple combo box (or drop down) from the
forms collection. (The combo box serves to have the user pick one of 12
months).

To make the control work, an "input range", and a "cell link" have to be
assigned - both usually as classic range-addresses on a worksheet.

Because of varying worksheets, I try to replace these 2 range-addresses by a
either defined name, or a constant, or an array, or anything else so as to
avoid range-addresses.

Any idea ?

Kind regards,

H.G. Lamy