Believe the source workbook will need to be opened. Comboboxes know nothing
about external links to closed workbooks.

--
Regards,
Tom Ogilvy


"jellobze1" wrote
in message ...

HI.

I'm using Excel VBA. I have a combo box in a template sheet with the
fillrange set to a range in a separate data sheet in another workbook,
workbook1. The combo box reads fine when I open both workbooks
separately and manually but when I use a command button from Workbook1
to open the template the combo box no longer shows my options.

I'm thinking the combo box needs to be refreshed after I open the
template. Is there any way to do this, since I tried
activesheet.cboChoose.refresh and got an error that "this object
doesn't support this property or method". I even tried
activesheet.cboChoose.requery and got the same error.

Any other ideas would be greatly appreciated.

Thanks in advance.
Angelo


--
jellobze1
------------------------------------------------------------------------
jellobze1's Profile:
http://www.excelforum.com/member.php...o&userid=28431
View this thread: http://www.excelforum.com/showthread...hreadid=480245