Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Select the Class module in Project Explorer (top left panel), in the
Properties window (typically bottom left panel but press F4 if necessary) you should see (Name) Class1 select "Class1" and rename to "clsChtEvents" If for some reason you can't do that, replace clsChtEvents with "Class1" in the normal module (I think in two places), and assuming the class you inserted is named Class1. Suggest head the modules "Option Explicit", which I see I forgot to include in the post. Sounds like this will be your first time to work with a class module (in this case a "withevents class". Keep in mind the module is "instanced" with the line Set mcChart = New clsChtEvents the class remains "alive" and responsive until the object reference "mcChart" is destroyed, eg Set mcChart = Nothing note editing code can also destroy the object ref, you can run the SetChart proc again if/when that ref' goes out of scope. Regards, Peter T "Pierre" wrote in message news:9036ef7d-610d-4bd7-I inserted a new Class "Class1" and tried to rename it to "clsChtEvents" to no avail. Obviously the sub SetChart() won't run. Please pardon my ignorance! Pierre |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlink to a specific place in a document | Excel Worksheet Functions | |||
Wingding character map | Excel Discussion (Misc queries) | |||
Find specific text and return coordinates | Excel Programming | |||
Simple way to convert UTM ED50 coordinates to decimal coordinates? | Excel Programming | |||
Converting MouseDown Coordinates to Chart Point Coordinates | Excel Programming |