VBA equivalent to Enum in C

[Jay]

Is there anything similar to the enum statement in C?

Eg, I can have four constants defined using this statement (if I remember my C correctly):

enum {NONE=0, TEST=1, ERROR=5, RETRY=7};

 

[Jezebel]

gee, well yes it does. It's called enum, oddly enough.

Public Enum MyENumValues
None = 0
Test = 1
Error = 5
Retry = 7
End Enum


The value assignments are optional. If omitted, sequential values are
assigned automatically.

 

[Jay]

Thanks Jezebel. Sorry for my late reply - very helpful.


Is there an equivalent to
gee, well yes it does. It's called enum, oddly enough.

Public Enum MyENumValues
None = 0
Test = 1
Error = 5
Retry = 7
End Enum


The value assignments are optional. If omitted, sequential values are
assigned automatically.