View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK[_3_] NickHK[_3_] is offline
external usenet poster
 
Posts: 415
Default Attribute statements of VBA Classes

Gogza,
I have not seen much on this, but there is so,ething like:

Public Property Get Text() As String
Attribute Text.VB_Description = "Gets/sets the text displayed in the column
header."
Attribute Text.VB_UserMemId = 0
Attribute Text.VB_MemberFlags = "200"

Not sure what the "200" signifies.

At a guess, download some complex VB6 classes/collection etc from the web
and look at them in a text editor. You may get lucky at picking up something
new.
I'll have a look with my VB6 when I'm in the office tomorrow.

NickHK

"gogza"
egroups.com...
How are we all today,

I know that I can set the Value property as the default property for a
class using:

Attribute Value.VB_UserMemId = 0

(see http://www.cpearson.com/excel/DefaultProperty.htm, if you would
like to know how to do this. Thanks Chip!)

And i know that i can set up an enumrator, NewEnum, for a class using:

Attribute NewEnum.VB_UserMemId = -4

But does anyone know where i can find documentation on these attribute
statements. If this is possible in VBA then what else am I missing?

Thanks,
Gogza