Propagation of ListFillRange property

[KMC1]

PROBLEM:
I'm trying to utilize VBA (Excel 10) to propagate "ListFillRange" properties

SETUP:
The are two columns, labeled: "Select JOB#" & "Select DRAWING#"
Each column contains (23) ActiveX Combo Boxes
Each "Select JOB#" Combo Box [perfectly] lists current jobs
Each "Select DRAWING#" Combo Box perfectly lists (+/- 200) pertinent drawings ONLY when I MANUALLY fill in the "ListFillRange" property

However, I would like to fill in the "ListFillRange" property based on the "Select JOB#" selection.

Below is typical VBA coding that I have tried:

Please Login or Register  to view this content.

Even by entering a named range, "MDL_1" (Current try), the "Select DRAWING#" combo box displays only "MDL_1" (or "$AV$1000:$AY$1700",or "$R$16:$R$16") instead of a list of (200) drawings.

How can I get the respective list of drawings to display in the respective Combo box?

(I just clicked the ListedDwg1 Combo box & all it shows is "MDL_1" with no additional drawing numbers)

Thank you for your assistance !!!

[stnkynts]

You stated you are using an ActiveX combo box but you are trying to access it like a Form Control combo box. OLEObjects is the collection of the ActiveX objects in a worksheet. Also note how I referred to the named range.

Please Login or Register  to view this content.

[KMC1]

stnkynts,

Tks for the super fast response !!!
Unfortunately, I am new to VBA & do not understand your awesome coding :-(

I copied the code to my spreadsheet, ran (F8) then (F5) the code (watching the expression: "myBox.AddItem (rCell.Value)"); however, I could not "see" any change in MDL_1 or "Value" on Watch screen ...

The ActiveX Combobox works perfectly when I manually enter "MDL_1" (no quotes) into the ListFillRange ...
I just don't understand why it won't do the same when I try to utilize VBA coding)

Again, TKS for your kind response