Posted to microsoft.public.excel.programming

Kigol

external usenet poster

Posts: 36

Dynamic ComboBox Reference

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamic combobox	alvin Kuiper	Excel Programming	1	February 10th 06 11:16 AM
dynamic combobox	john_t_h[_22_]	Excel Programming	11	September 14th 05 02:48 PM
Combobox with a dynamic list	Arishy[_2_]	Excel Programming	12	August 12th 05 02:07 PM
Dynamic ComboBox	Helen	Excel Programming	2	December 7th 04 08:57 PM
Dynamic update on ComboBox	Kevin	Excel Programming	4	October 14th 03 12:45 PM

All times are GMT +1. The time now is 03:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us