Solved

Count of Enum ???

Posted on 2001-09-09
5
1,392 Views
Last Modified: 2009-12-16
Hi.

How can i know (if i can) how match prop in Enum.

Exsample:

Enum Test
  A = 10
  B = 20
End Enum

Need to get 2.

that then i can do loop like this :

for i = 1 to UBound(Test)...
next i

0
Comment
Question by:Alon1001
5 Comments
 
LVL 7

Expert Comment

by:Vbmaster
Comment Utility
No can do. Unless you store the values somewhere else (in a string array or something) you can not get the name of the enum variables, nor the values.
0
 
LVL 6

Accepted Solution

by:
andyclap earned 50 total points
Comment Utility
A common pactice is to use two extra values, for example
Enum Test
 [Test_Min]=10
 A = 10
 B = 20
 [Test_Max]=20
End Enum

by putting the square brackets around the values, you can hide them from the normal properties list. It's usually used for sequential enums.
0
 
LVL 22

Expert Comment

by:rspahitz
Comment Utility
Enum is a numbered list of constants.

In the same way that you really can't ask VB to give you a count of how many variables you've used, you also can't ask it to give you how many constants you've used.

For example,

Enum Test
 A = 10
 B = 20
End Enum

is the same as

Const A = 10
Const B = 20

except that they are grouped together under the "object" name of "Test".  This "object" does not have any properties, methods or events so you can't do much with it except use it's "variables."
0
 

Author Comment

by:Alon1001
Comment Utility
Yes, u right - Enum is like const, but maybe have
api function that give the size of the object ???
and then maybe i can have the number "variables" in the
Enum ?

0
 
LVL 22

Expert Comment

by:rspahitz
Comment Utility
I've never seen a way to get that, but maybe there's a way using the Scripting object, since it allows you to get other "internal" program stuff.
0

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now