VBA equivalent to Enum in C

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jay - 02 Feb 2006 11:58 GMT

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};

Reply to this Message

Jezebel - 02 Feb 2006 12:35 GMT

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.

> 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};

Reply to this Message

Jay - 06 Feb 2006 13:43 GMT

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.

Reply to this Message