I have a vendor product that uses an Excel VBA API for access to data. One of the routines provides a key set of data values only by passing in a combobox and letting their routine populate it. I can then process the data in the combobox to get the data I need.
Some applications of this data lend themselves to a UI display of a combobox and letting the user choose. I have an application then needs to be entirely automatic (no user intervention). Therefore, I need to create a combobox to pass to their routine without the display of a datasheet or user form with the control on it.
I have searched a number of sources (printed and online) and have not found a way to do this. I realize it may be a bit "unusual", but I'm beginning to wonder if it is possible at all? Is there a way to do this ... how?
Bookmarks