Excel VBA Introduction Part 26 - Constants and Enumerations (Const, Enum)

By Andrew Gould

[houstonvanhoy]

Andrew: This video just blows my mind! Thanks.

[jmathew]

Excellent Tutorial! Best part is the the examples used. Gives you 200% understanding of the topic, if not more. Thank you.

[adamderose]

Great tutorial; very easy to understand and in-depth at a good pace for me. I coded along and replayed tons of times.. this and the Arrays tutorial has helped me broaden my beginner's skill set. Thank you!

[timusolds]

Dear WiseOwl!!! 
Thank you very much for you videos!!! Many thanks from KZ and DE!!!
Your Videos are just awesome!!!
A

[tavanix]

Best VBA totur ever! Thank you very much WiseOwl, and many thanks to Andrew personnaly!

[khalidalisawi]

great tutorial, When I see it. and left all videos which I followed before and follow you

[SyedKollol]

This is the first time I really liked any video on these particular topics. 
Excellent work and thanks a lot.

[abdulnayazh]

All your videos are awesome man thanks....

[vk]

Excellent videos. Thank you for the tutorials.

[tomash]

Oh yeah finally easy to follow video  after tougher ones :)

[Gk_]

very informative ... it helped me a lot ..

[tanmoyd]

Very informative video - I can't stress it more!

Can you please do a video on Constants, Variables and Enums while using VBA for PowerPoint? I really need to know. I am experiencing issues while using Constants for Colors in PowerPoint VBA.

[IndiaDefenceWing]

I follow your every single video. Currently I am struggling with UIAutomation in VBA. Could you please create some videos on it and help me with any material if available.

[SemperFiParatus]

I'm loving your tutorials. They are informative and accurate. I personally think that if you reinforced your examples by including features learned in earlier models that you'd have a greater following. In every video so far you have failed to use the the [Procedure View] / [Module View] buttons in the bottom left corner of the VBE which really helps me focus on the task at hand by hiding separate modules. The following function would have done the exact job you wanted in the circle example. I am surprised you never used it:
WorksheetFunction.Pi
Brilliant work so far!

[DittoGlen]

In regards to Pi constant,  WorksheetFunction.Pi is also available (at least Excel 2010 its there)

[mahdjoubsofiane]

As usually fantastic style of description
I have only one question :
What is the key difference between enumerations and collection !
And many thanks in advance

[pallikishor]

Hi Andrew,

I have got stuck at one point, need your help. actually I want to pass variable name through cell reference in sheet. If that variable is present in the declared list of the module then corresponding value should come into the reference cell. can we acheive it anyway? If yes, Please guide me. It will be really helpful. Thanks in advance.

[stephenhammond]

I have started using enums and classes and find they make coding easier. Wondering if it is possible to use an enumeration in a WITH statement. Eg Define an enum named Address and then say With Address....? Is this possible?

[artistryartistry]

Why combine one concept people are trying to learn with something more complex like the area of a circle? Why not pick an example everyone understands intuitively, so they're not trying to learn the concept while dealing with additional unnecessary complexity? Why not use something like a tax rate or hours in a day, vs. Pi and area of a circle? Great tutorial, but keep it as simple as possible.