What Attributes have been implemented in VBA?
-
Saturday, December 26, 2009 5:07 PM
My question concerns the use of Module-level and Procedure-level Attributes in VBA.
Microsoft's VBA Language Specification describes these Attributes in:3.3.5.2 Reserved Identifiers and IDENTIFIER
The document identifies a large group of these identifiers as "<reserved-for-implementation-use>". As I read it, this means that the Attributes in this group are made available to whomever implements the actual programming language, but not necessarily implemented by default. However, I know for sure that at least one of these has been, in fact, implemented in Microsoft's VBA programming language. It is the attribute, "VB_UserMemId". By setting this value to 0 in a Property procedure, one may create the default property for a class. by setting this attribute to a value of -4 in a Public function, one may create a method used to enumerate the objects in a custom collection class.
My problem is that I cannot find any documentation that specifies any other attributes that may have been implemented by Microsoft. I have been to the end of the internet, and increasingly, I fear that the document just does not exist. Does anyone have any information that provides a list of which Attributes can be used in VBA and examples of how to use them (i.e. purpose, syntax, and possible values)?
Thanks for any resolution to this problem.
Answers
-
Tuesday, March 16, 2010 7:22 PM
Hello Ryan,
I was trying to find some information on "Attribute" and found this post: http://www.cpearson.com/excel/DefaultMember.aspx. Looks like that there is a workaround.
Nadia- Proposed As Answer by NadiaSz Monday, March 22, 2010 1:49 PM
- Marked As Answer by PaulYuk_MSMicrosoft Employee, Owner Friday, September 10, 2010 7:24 PM
All Replies
-
Tuesday, March 16, 2010 7:22 PM
Hello Ryan,
I was trying to find some information on "Attribute" and found this post: http://www.cpearson.com/excel/DefaultMember.aspx. Looks like that there is a workaround.
Nadia- Proposed As Answer by NadiaSz Monday, March 22, 2010 1:49 PM
- Marked As Answer by PaulYuk_MSMicrosoft Employee, Owner Friday, September 10, 2010 7:24 PM
-
Friday, June 18, 2010 11:09 PM
You are welcome, Antonia.