Hi all,
I've stripped away all code irrelevant to the issue I'm having, but I'm working on a custom class that represents an autocomplete object. The object will consist of a TextBox, a ListBox, and a Label, all dynamically created. For now, I have just a ComboBox. It will place itself in any cell on BeforeDoubleClick, and autocomplete your typing based on a named range. The object gets instantiated as a global variable in Sub Main(), and uses with only two methods, Show() and Run(), in Worksheet_BeforeDoubleClick.

Now to the issue: How do I adjust the code so that the events don't have to be in the Worksheet? I want them in the main class, if possible. (I'll settle for in a separate class if I have to.) Thanks for your time. Here's the code:

First, the worksheet module:
Please Login or Register  to view this content.
Second, the standard module:
Please Login or Register  to view this content.
Third, the class module named CMGAutoComplete:
Please Login or Register  to view this content.
Fourth, my attempt at separating the object's events into a separate class module. (Again, I'd rather just include these in the CMGAutoComplete class.)
Please Login or Register  to view this content.