Alternative to ActiveX control in Sheet?

[ClimoC]

Howdy

So the project I'm doing has me at a crossroads.

The PERFECT candidate for what I'm trying to achieve is a Frame control. It's isolated, scrollable... it's just that in a worksheet they're the devil.

Simply trying to add one at runtime throws up odd exceptions and bugs ("Cannot enter break mode at this time" - 'Continue') and "Cannot add object" at seemingly random times).

In lieu of the Frame - any ideas? I need a 'container' (as I will be dynamically adding many of these) that has a dynamic number of objects inside it (buttons/controls) - and can be scrolled through (otherwise there could be 10 columns used on one row, 5 on another...)

 

[Kyle123]

Why not just use a big userform? As a rule of thumb, one should always avoid activex controls on worksheets

 

[ClimoC]

This is where my head's going too Kyle.

Almost wish I'd done the other similar modules (which don't require this scrolling feature) the same, so as to at least be consistent. I was hoping to reuse a lot of the classes and collections and such.

C'est la vie.

At least a form would be easier than a spinner, and having to keep 'page numbers' and bookmarks with my recordsets...

 

[Kyle123]

Not that it helps much, but I feel for you.

You live and learn