Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi NG,
I've created a class that builds on a (large) Label and, with a host of other labels (placed beneath the main label), acts as a clickable grid. This grid is placed on a userform at run time. The events, selection of objects etc. are handled within the class. I want to expand this however such that an event such as a doubleclick on certain objects will fire as an event within the parent userform's module i.e. expose something like: Private Sub myGrid_DblClick(myRow as integer, myCol as integer, _ myID as integer) End Sub My assumption is that this isn't possible since the Grid isn't instantiated until run time. (And I would definitely rather not have the class module calling a procedure within the userform.) Is my only option to make an OCX for this class so I can incorporate it at design time (and accept all the deployment issues) or am I overlooking something? Thanks for any help, Gareth ....The answer may well be in my copy of Power Programming by Mr Walkenbach but it's packed up in boxes with all my other books... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Useing Class structures and Events | Excel Programming | |||
class events stop firing with ADO 2.8 | Excel Programming | |||
Events, Class, Time Editing | Excel Programming | |||
RaiseEvent from a class contained in a 2nd class collection? | Excel Programming | |||
What events can be captured in a Class Module? | Excel Programming |