Dynamic ComboBox Reference

's Computer Specifications

Hello,

Is there any way to dynamically refer to an object on a Form such as
the two methods listed below for 18 different ComboBoxes? Neither
work. I know there must be a way. Thanks.

Call Get_Headings(columnarray())

For i = 1 To 18
Me.Controls("ComboBox" & i).List
'ComboBoxi.List = columnarray
Next i

's Computer Specifications

On Jun 25, 12:19 pm, Kigol <raw4...@aol.com> wrote:
> Hello,
>
> Is there any way to dynamically refer to an object on a Form such as
> the two methods listed below for 18 different ComboBoxes? Neither
> work. I know there must be a way. Thanks.
>
> Call Get_Headings(columnarray())
>
> For i = 1 To 18
> Me.Controls("ComboBox" & i).List
> 'ComboBoxi.List = columnarray
> Next i

Haha I forgot to set the list equal to something. How embarrasing.
Please delete.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic Combobox	Dennis	Microsoft Excel Programming	2	6th Apr 2008 08:28 AM
How do i set up a 3d reference where one cell reference is dynamic	SmilingSteve	Microsoft Excel Misc	15	14th Mar 2008 05:05 AM
dynamic combobox	john_t_h	Microsoft Excel Programming	8	11th Sep 2005 02:03 PM
Dynamic ComboBox	Helen	Microsoft Excel Programming	2	7th Dec 2004 08:57 PM
Load dynamic data into comboBox based on input in ComboBox	=?Utf-8?B?SmFzb24gU21pdGg=?=	Microsoft Dot NET Framework Forms	1	31st May 2004 05:21 AM