HI.
I'm using Excel VBA. I have a combo box in a template sheet with th
fillrange set to a range in a separate data sheet in another workbook
workbook1. The combo box reads fine when I open both workbook
separately and manually but when I use a command button from Workbook
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 th
template. Is there any way to do this, since I trie
activesheet.cboChoose.refresh and got an error that "this objec
doesn't support this property or method". I even trie
activesheet.cboChoose.requery and got the same error.
Any other ideas would be greatly appreciated.
Thanks in advance.
Angel
--
jellobze
-----------------------------------------------------------------------
jellobze1's Profile:
http://www.excelforum.com/member.php...fo&userid=2843
View this thread:
http://www.excelforum.com/showthread.php?threadid=48024