Hello guys,</SPAN>
I was wondering: is it possible to link an ActiveX Controls (Combo box) and normal Combo boxes to data in other workbooks?
</SPAN>
I would prefer to keep the data separated from my “Fill in” workbook (workbook that contains the Combo boxes), because the data will have to be regularly updated by the users (F.e.: Create a new customer, ..). I’d rather have the “fill in” file not saved, in order to prevent errors.
</SPAN>
Anyone has any ideas?
PS: I have tried name manager, and creating links between 2 Workbooks by using specific names). This works for the normal Combo boxes, but it didn’t work with the ActiveX Controls..
And I was wondering if there might be any other options.
</SPAN>
Thanks in advance!
</SPAN>
Yves</SPAN>
(Excel 2010)
I was wondering: is it possible to link an ActiveX Controls (Combo box) and normal Combo boxes to data in other workbooks?
</SPAN>
I would prefer to keep the data separated from my “Fill in” workbook (workbook that contains the Combo boxes), because the data will have to be regularly updated by the users (F.e.: Create a new customer, ..). I’d rather have the “fill in” file not saved, in order to prevent errors.
</SPAN>
Anyone has any ideas?
PS: I have tried name manager, and creating links between 2 Workbooks by using specific names). This works for the normal Combo boxes, but it didn’t work with the ActiveX Controls..
And I was wondering if there might be any other options.
</SPAN>
Thanks in advance!
</SPAN>
Yves</SPAN>
(Excel 2010)
