working with a Custom Type

hi guys!

I'm not at all familiar with the proper technical names for what I want.... so I'll just demonstrate to you the end result I'm looking for:

What i what is to create a custom type (named Estimation) used in the following way:

Please Login or Register  to view this content.

Where "Type=" would bring (intellisense) Robust , Adaptive , Standard or NoneStandard as possible constant options to choose from.
The Estimation type has more stuff in it of course, but I'm focusing on this one particular property, in here.

My question is this:
Am I using the wrong object (custom type) where this syntax would be more (or only) typical for a custom Class rather than a custom Type?
Is that why I have not been able to set it (and could never do...)?

I just want a way to save me from explicitly typing "Robust" or "Adaptive" or another ... every time I want to configure the Type property for Estimation, but have an already set of constant choices to choose (to avoid typos and save time..).

Thank you!

Please Login or Register  to view this content.

EDIT: Type is not a great name for an element in a user-defined data type.

Thank you!
Enum... never knew about that!

Type is not a great name for an element in a user-defined data type.

Could you explain, please?

I could go with "Kind" or "Category" or another synonym... would that improve anything? What am I to take from your comment, I'm not entirely sure..?
Is it the use of the word Type itself that is inappropriate or is it a syntax/readability kind of issue (since Type is already "used" and may be confusing at times... or something else maybe?

VBA is case-insensitive as to variable names, but the case of every variable, property, procedure, ... of the same name follows the case of the last declaration. So if you change the element name from "Type" to "type", it will change the case of "Type" throughout the project. Not a problem, just a confusion I prefer to avoid.