ComboBox RowSource assignment by procedure code?

[TTom]

ComboBox RowSource assignment by procedure code:

In a module sub I want to have code that assigns the RowSource value to a named ranged prior to
showing the UserForm that contains the ComboBox where the RowSource is to be filled.
(This will fill the ComboBox with named range data.)

The following code gets an error as invalid. Is RowSource assignment by code not allowed for Comobox, or do I just need to tweak my code?

Thanks for any tips. TTom
<code>
ActiveWorkbook.Names.Add Name:="nrng_Jobs", RefersTo:="=Sheet2!$T$1:$T$" & Range("T6000").End(xlUp).Row

ufJobSelect.cbxJobSelect.RowSource = "nrng_Jobs"
</code>

 

[TTom]

Even if I type in the named range, or even just a 'single cell range' into the ComboBox's RowSource
property setting I get an 'Invalid Property Value" error. Hmmm....
TTom

 

[Norie]

Are you sure the range is being defined correctly?

With Worksheets("Sheet2")
    LastRow = .Range("T" & Rows.Count).End(xlUp).Row
    .Range("T1:T" & LastRow).Name = "nrng_Jobs"
End With

 

[TTom]

Norie,
This resolved my problem
I'll have to study my named range assignments! :wink:
Thanks, TTom

 

[Norie]

I don't actually think it was anything to do with that.

I think the problem was the unqualified reference to Range("T6000").

Could be wrong though.