Комментарии:
Every time I feel happy when I get an information that you uploaded a new video because I know that it is going to be very helpful and quite useful. Thanks indeed Paul. 👏 🌟 🌟 🌟
ОтветитьThank you.
Sometimes I wonder what is the gain in VBA speed all over the world (and economical gain for that matter) thanks to these lessons.
Why shData not error "variable not defined" sir?
ОтветитьI would add 2 more areas to that:
Forms (developing apps) and classes/interfaces 😄
Thank you for the basics. I'm a bit confused, in the example you are Debug.printing the Dictionary results, but how do I transfer the results to Excel?
ОтветитьThank you.. It was nice video..
ОтветитьThank you so much paul.
ОтветитьAWESOME VIDEO! Perfect for finding yourself in this forest of knowledge!
ОтветитьHi. I am getting Compile error: Variable not defined when I use sub UseRanges(). How to solve it?
ОтветитьGreat channel! Thanks!
ОтветитьDear Sir,
for the dictionary part,
if the value (amount) of the key (Fruit) is zero in sum, will it be shown in the dictionary?
i just wanna be using the dictionary for my inventory record, sometimes it may be zero in number.
Great, dictionary was new for me!
Ответитьhello there ! General Kenobi !
ОтветитьEasy to follow and understand tutorial. Thank you
ОтветитьGod of excel VBA..🙏
ОтветитьIs there a reason you use Long for the row in your dynamic ranges example? Naively I'd think that should be an integer; like, what would happen if you gave it a fractional value? I'm totally new to excel vba, so please forgive me if excel or vba does something I don't know about which makes this the best practice.
ОтветитьAhh. I see that you've changed the name of the sheet to shdata. That answers my question.
ОтветитьShData isn't an object, at least in Office 365 version of Excel.
ОтветитьGo raibh maith agat. An-úsáideach mar i gcónaí.
ОтветитьThe example of the Ranges doesn't work and gives me the Run Time Error 424 and I have meticulously verified the code I typed to what is in the video. does anyone know why this would be? I'm currently on Office Home and Student 2016. Thanks in Advance.
ОтветитьBut is the efficiency so much bigger working in VBA instead of working direct in the spreadsheet?
ОтветитьQuestion about the dictionary. The for each loop at the end you say currentKey in dict.Keys. The currentKey make sense cause you declared it as a variant. Where did the .Keys plural come from?
ОтветитьPlease , i have this problem, my code
for i = 1 to 100
if worksheets(“sheet1”).cells(i,1).value = i ————this dont work
when i change i to 1 it works like this
if worksheets(“sheet1”).cells(i,1).value = 1———–work
i try convert the cell covert the every value no way , thanks
You are a Champ, thanks and God bless you.
✌😀
I really like your videos and respect your work... however, that has got to be the worst ever example of what a function is and how to use it.
Bro, the main reason you use functions is to be able to include them as part of formulas (i.e. a text formula that includes regular expresions) or to consult data from external DB's (a function that gets a Part Number from a DB of vendors). All without the need to include buttons or to map them on your interface, you just type = then start typing however you named your function and voila.
Amazing Video
ОтветитьWell done
ОтветитьYou're a very gifted educator Paul. I've been programming for years in VBA, and you keep showing me all kinds of things I had no idea about. Excellent content taught in a very friendly manner.
ОтветитьExcellent video again, thanks!
ОтветитьCan u please give ur suggestions on how to use intellisense...
Some times it doesn't work and make feel worry sometimes..
Example.. Activesheet.paste will not be shown with intellisense... I know that it has to do something with object library...
Can u please make video how to use object library
Hi Paul, big fan of your channel. Do you do vba consultancy?
ОтветитьHi Paul. It's amazing knowledge. Thanks for sharing.
ОтветитьThank you for your video. I'm using vba for a while but learnt a lot from your video to simplyfy my code. Currentregion is a very usefull code i didnt know that realy like it. Nowdays im working with data where there are blank rows what i cant delete. Do you have any tool how to handle this type of database?
ОтветитьThanks for making these videos, they've been extremely helpful to me! Clear, concise explanations in terms I can grasp, and the pace is spot on👍,subscribed.
ОтветитьAwsome video! If you want to, check out my channel where I show how you can turn Excel files into web apps without coding or extra software!
ОтветитьYou are the KING of VBA
ОтветитьCan u please give ur suggestions on how to use intellisense...
Some times it doesn't work and make feel worry sometimes..
Example.. Activesheet.paste will not be shown with intellisense... I know that it has to do something with object library...
Can u please make video how to use object library
Can we use AND in case statement??... How do i write?? For example the below code doesn't work
case > 1500 and < 2000..
Nice video to refresh and revise ur understanding... Thanks paul
ОтветитьHit like and watch the video
ОтветитьExcellenttttt..... Thanks for the video..
ОтветитьWell done Paul.
As always, very clear and didactic.
Thanks Paul.
ОтветитьCould you teach the use of listviews instead of listboxs?
ОтветитьGreat , Thanks
ОтветитьExcept the dictionary part I can say I know the other ones, but still I m afraid to apply for a vba developer job because I don t know which are the expectations ...
ОтветитьThat was great. Saved off the link. I'd not heard of using CurrentRegion before. That'll be very helpful.
ОтветитьThis must be some record - 3 days of VBA training squeezed into 28 minutes. Bravo!
Ответить