LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #11   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 593
Default How to extend a standard class (like Worksheet)

"mike" wrote ...

I've tried to
implement (not to extend) an interface like Sheet1's.
Arrived to the member _CodeName I was in impossibility of
implementing it in my class (which, again, was
implementing (!) the Sheet1 interface) because VBA says
that "cannot use _ as the first character in variable
name".
There is any workaround? Worksheet cannot be implemented
as an interface.


I'm now not clear on what you are using as an interface: Sheet1 or "an
interface like Sheet1's"?

My interfaces are VB class modules containing just the declarations of
the properties and methods.

I've never tried implementing an interface created any other way. I
assume the Sheet1 object/class is not a VB class module containing
just member declarations, I doubt it is even a type library, so I
assume it cannot be used with the Implements statement.

Perhaps you should post your code so we can see what you are
attempting.

Jamie.

--
 
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
how to extend the column limit on a worksheet Jackie Excel Worksheet Functions 1 May 30th 07 04:18 PM
How do you extend the number of blank columns in a worksheet? mybicycleisgreat Excel Worksheet Functions 4 February 5th 06 03:41 PM
DisplayGridlines should be a property of Worksheet class, not Wind Stefano Gatto Excel Discussion (Misc queries) 5 August 25th 05 08:27 AM
I need to do a Worksheet for my Financial Accounting Class. What . vman Excel Worksheet Functions 3 February 18th 05 10:07 PM
Copy Method of Worksheet Class Failed Steph[_3_] Excel Programming 1 April 5th 04 09:56 PM


All times are GMT +1. The time now is 06:11 AM.

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"