It is possibe to create your own.
Beware using floating point values with Enum. All constant values are treated as long integers rounded to the largest integer.
The default type is Integer if omitted.

Public Enum OverWrite As Integer 
   owYes = 1
   owNo = 2
   owNoToAll = -2
   [anotherone] = owYes ??
End Enum

If you don't specify any numerical values the enumeration will start at 0 and each subsequent value will incrememt by 1.

Public Enum enTemperatue 
   Constant1 'this will have the value 0
   Constant2 ' this will have the value 1
   Constant3 = 20
   Constant4 'this will have the value 21
End Enum

Public Enum enTemperatue As Long 
   Constant1 = -20
   Constant2 = 0
   Constant3 = 10
   Constant4 = 35
End Enum

Case Sensitive

you can declare enumerations in mixed case but while using them in your subroutines you type them in lowercase it will change the original declaration to lowercase


This functionality was added in Office 2000.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext