Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combo box problem
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combo box problem | Excel Discussion (Misc queries) | |||
Combo Box problem | Excel Discussion (Misc queries) | |||
Combo box problem | Excel Programming | |||
Combo problem again | Excel Programming | |||
combo box problem | Excel Programming |