LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,600
Default Place wingding on specific coordinates - possible?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlink to a specific place in a document Al Excel Worksheet Functions 3 June 29th 09 05:53 PM
Wingding character map David Excel Discussion (Misc queries) 4 February 3rd 09 09:36 PM
Find specific text and return coordinates BOONER Excel Programming 4 May 9th 06 09:42 PM
Simple way to convert UTM ED50 coordinates to decimal coordinates? Dan[_38_] Excel Programming 8 July 11th 04 04:54 PM
Converting MouseDown Coordinates to Chart Point Coordinates Steve[_50_] Excel Programming 3 December 2nd 03 06:48 PM


All times are GMT +1. The time now is 06:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"