Great video!, I use enums a lot to avoid magic numbers for column references etc but my favorite use is for storing application colors (RGB just evaluates to a long anyways). Makes changing them throughout the app very easy.
Thanks. I have a use for this right now. After watching your 2 videos on Enums, I was only left wondering 1 point. Since the enum values are longs, can I just use the long. For example could I write eEmployeeType=0 rather than eEmployeeType=e_FullTime. I assume yes but for ease of use purposes that might be easy as well. Anyway, thanks for the help.
Great video and very easy to follow and understand. Thank you!
Brilliant! Please do more videos on classes
Great video!, I use enums a lot to avoid magic numbers for column references etc but my favorite use is for storing application colors (RGB just evaluates to a long anyways). Makes changing them throughout the app very easy.
Thanks, using select case to execute different process inspired me a lot. And Enumerations do help ceasing mistakes causing by typo.
HI Jen. How Can you assign a String Value to enumerations.
I.E.
Public Enum eNumName
eFirstname = "Jen"
eLastname = "Garth"
end enum
Thanks. I have a use for this right now. After watching your 2 videos on Enums, I was only left wondering 1 point. Since the enum values are longs, can I just use the long. For example could I write eEmployeeType=0 rather than eEmployeeType=e_FullTime. I assume yes but for ease of use purposes that might be easy as well. Anyway, thanks for the help.
You might want to add to your channel's name something like: VBA Excel, to be easily found. Have no idea if it helps but you never know.