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:

Please Login or Register  to view this content.
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.