Filling array into Combo box

srirajgopinathan

New Member
Joined
Mar 13, 2011
Messages
2
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
 

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

Marcelo Branco

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,393
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

New Member
Joined
Mar 13, 2011
Messages
2
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

MrExcel MVP
Joined
Aug 23, 2010
Messages
16,393
Hi,

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

M.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,437
Messages
5,528,761
Members
409,834
Latest member
vexceled

This Week's Hot Topics

  • Change military grades into rank
    Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
  • VBA COUNTIF SOLUTION
    Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
  • INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
    Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...
  • Auto-Create a monthly Sign in sheet for preschool students
    The image below is what each page looks like. Above is space for the "Child Name" "Month" "Class" School days are obviously Monday-Friday but...
  • VBA vlookup multiple results
    Hi folks, Hopefully someone out there can help. I have a list to vlookup which works (ish). the lookup only picks up the first instance of the...
  • Extract values for earliest/latest times
    I am trying to put together a formula to get the earliest start time, the latest end time from column A for each person in Column B-F without the...
Top