Filling array into Combo box

[srirajgopinathan]

Hi

I am new to this forum, and would like to get help on the usage of array inside a combo.

I am tring to populate a combo box (single coulmn) with an array (dynamically created) . But Iam not sure how to do it. Would like to get get help from this forum

I am trying to get something like 'combobox1.Value=Myarray'

Thanks in advance
Sriraj

 

[Marcelo Branco]

Hi Sriraj,

Welcome to the forum!

If you are using an ActiveX ComboBox, right-click, pick Properties and insert the name of your dynamic range in the text box beside the property ListFillRange.

If you are using a form control in your worksheet, right-click, Format Control, pick the tab Control and insert the name of your dynamic range in the first textbox (Input Range). Choose also a cell as Cell link.

HTH

M.

 

[srirajgopinathan]

Thanks for the quick response.

I would require the dynamic nature in selecting the range as well.

The row selected for the range would change based on some conditions.

myrange=range(cells(i,j), cells(i,j+c)). Where i, jand c depends on some previous conditions.

Can I give a dynamic range like this in the combo properties?

Is there any way to fill the combobox from the array which has go the data from that range, using VBA code?

Thanks
Sriraj

 

[Marcelo Branco]

Hi,

Where is the ComboBox, in a userform or in a worksheet? If in a worksheet is it ActveX or Form control?

M.