In my experience, adding forms directly to Excel sheets causes issues
like this to occur. The only fix I've discovered is the one you came
up with below (or similar approaches). You may find that focusing a
particular dropdown will cause the problem to reappear, in which case
you'll also need to
s to act as an
intermediate dispatcher for all onAction calls with shapes, I should
be able to capture any sheet-based action after a VBA crash and reset
all my classes via the class I've defined.
On Jan 27, 4:45 pm, RationalIcthus wrote:
> When I build an instance of a class that I've c
When I build an instance of a class that I've created in Excel VBA,
then enter Design Mode (or if an unhandled error occurs) my object
variables disappear (I think because code execution stops
completely). Problem is, if I'm trying to maintain state within a
class across the life of an Excel appli
