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

preview_player
Показать описание


By Andrew Gould

Рекомендации по теме
Комментарии
Автор

Andrew: This video just blows my mind! Thanks.

houstonvanhoy
Автор

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

jmathew
Автор

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!

adamderose
Автор

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

timusolds
Автор

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

tavanix
Автор

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

khalidalisawi
Автор

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

SyedKollol
Автор

All your videos are awesome man thanks....

abdulnayazh
Автор

Excellent videos. Thank you for the tutorials.

vk
Автор

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

tomash
Автор

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

Gk_
Автор

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
Автор

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.

IndiaDefenceWing
Автор

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
Автор

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

DittoGlen
Автор

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

mahdjoubsofiane
Автор

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.

pallikishor
Автор

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?

stephenhammond
Автор

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.

artistryartistry
join shbcf.ru