Hi all,
I'm tryiing to create 'filterArray' which is a self populating set of combo / list boxes that allow users to generate a set of values on which to filter a range of 'other data'.
The 'other data' is generated on the fly and posted in to a new sheet so I would like to be able to add the filterArray on the fly using something like:
however the add method seems to fail is the class is user defined.
Is there any way to add a custom class to the OLEobjects class? Or even better to make a custom class behave like an OLEobject?
Your wisdom is appreciated.
Bookmarks