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

[@houstonvanhoy7767]

Andrew: This video just blows my mind! Thanks.

[@WiseOwlTutorials]

Happy to hear you enjoyed it!

[@jmathew6988]

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

[@WiseOwlTutorials]

Thanks J!

[@khalidalisawi8037]

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

[@WiseOwlTutorials]

Thank you Khalid!

[@timusolds3537]

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

[@adamderose9468]

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!

[@tavanix]

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

[@SyedKollol]

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

[@abdulnayazh2366]

All your videos are awesome man thanks....

[@nazaserh]

Simply brilliant 👏

[@WiseOwlTutorials]

Thank you Serge!

[@vk452937]

Excellent videos. Thank you for the tutorials.

[@MagnusAnand]

Excellent video!!

[@Tan_Rainbow]

Excellent videos

[@tomash9785]

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

[@thomasfergusen5144]

great series

[@AmitSharma-po1zb]

Simply Awesome... :)

[@WiseOwlTutorials]

Thanks Amit!

[@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.

[@WiseOwlTutorials]

Hi Sunil, I don't have any experience with UI Automation so it's unlikely that we'll have any videos on that topic, sorry!

[@IndiaDefenceWing]

@@WiseOwlTutorials Thanks Andrew. The best part about you is you always reply. Thanks Andrew and keep up the excellent work. It encourages us as well to learn beyond limits.

[@WiseOwlTutorials]

@@IndiaDefenceWing Thank you Sunil, I appreciate the support!

[@adambooth3858]

Great tutorial. Thanks.

[@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!

[@SemperFiParatus]

It's great! The resource is really helping me improve my skills. It would be rgeat to have a set that demonstrates how to build an excel application using VBA so that users can see something built from scratch that has a real world function and is useful like an accounting program that does double entry T accounts. Students would be able to recode it to their needs and learn how valuable VBA is to their job. Your teaching style is brilliant.

[@Gk2810_]

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.

[@tanmoyd]

+WiseOwlTutorials Thanks a lot! I understand :)

[@mahdjoubsofiane4005]

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

[@WiseOwlTutorials]

Thank you Mahdjoub! There are many differences between enumerations and collections. You might find the video on collections useful here kzbin.info/www/bejne/bpelhoiJp9KmhpY I hope it helps!

[@scotolivera8207]

Thanks a lot.

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@DittoGlen]

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

[@krn14242]

Thank you

[@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.

[@danielpenteado]

You rock!! Thks!

[@victoropere2107]

awesome

[@stephenhammond1745]

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?

[@WiseOwlTutorials]

Hi Stephen! Unfortunately not, an Enum is just a set of related constants. A With statement needs to work with an object. You could use a Type to do the sort of thing you need. A basic example would look like this: Public Type Address Street As String Town As String Postcode As String End Type Sub With_Address() Dim a As Address With a a.Street = "Some street" a.Town = "Some town" a.Postcode = "AB12 3CD" End With End Sub You could use an Enum to set the datatype of one of the members of the Type like so: Public Enum CountryEnum Australia = 1 UnitedKingdom = 2 UnitedStates = 3 End Enum Public Type Address Street As String Town As String Postcode As String Country As CountryEnum End Type Sub With_Address() Dim a As Address With a a.Street = "Some street" a.Town = "Some town" a.Postcode = "AB12 3CD" a.Country = UnitedKingdom End With End Sub I hope it helps!

[@stephenhammond1745]

@@WiseOwlTutorials Ok. I had read somewhere that enums were technically considered objects but maybe that's not true or they just can't be used like other objects. I've just started looking into Types....still fairly new at this (68, retired, and using VBA as a way to keep my brain engaged). Thanks a lot for taking the time to reply. Your feedback/suggestions are very helpful.

[@WiseOwlTutorials]

@@stephenhammond1745 It's super impressive that you're in to class modules and types already - it took me ages to wrap my head around those when I was getting started!

[@stephenhammond1745]

@@WiseOwlTutorials I took me a while to understand that these were aids to coding rather than ways of gathering user input when the code was running. Once I realized that, using them was fairly easy. Now it's more a matter of deciding which to use in any particular case.

[@artistryartistry7239]

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.