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