combobox rowsource as code

How do I specify a rowsource in VBA

Combobox1.rowsource = range (testrange)

where testrange is a named range in excel. This is so I can dynamically fill in some comboboxes.

Thanks,
Jason

I like:

Combobox1.rowsource = range(testrange).address(external:=true)



JasonSelf wrote:
>
> How do I specify a rowsource in VBA
>
> Combobox1.rowsource = range (testrange)
>
> where testrange is a named range in excel. This is so I can
> dynamically fill in some comboboxes.
>
> Thanks,
> Jason
>
> --
> JasonSelf
> ------------------------------------------------------------------------
> JasonSelf's Profile: http://www.excelforum.com/member.php...fo&userid=5330
> View this thread: http://www.excelforum.com/showthread...hreadid=467237

--

Dave Peterson