Video

Thanks for this. First time I understood the need and usage of implementations.

Best of luck brother

Good thanks so much

Hi Ismail Nice work. I would however suggest you something to improve. Since people come to learn often, you should go slowly otherwise only people with a certain level of expertise can follow. Thanks

you can just define their types as IEmployee, in that way we are not dependent on contractual, permanent or temporary employee

Good morning, and thank you for sharing this information! I wanted to increase my game so much and this does it!

Thank You Thank You Ismall. I have been looking for something like this for over three years. There are many macros to highlight rows; however, you need to type in a macro for each worksheet. When I asked how the macro can be put into the personal macro workbook, so it can be used on any worksheet; I was told it cannot be done. You saw one of my latest posts to another podcast and wrote an add-in to handle this problem. Your add-in allows users to very easily find the active cell. The arrows used do not cover up conditional formatting. The arrows point directly to the active cell. The arrows can easily be turned off or on. Once the add-in is installed, it can be used on any worksheet/workbook.

This is just what I nedded thank you very much. Unfortunately the order you place in power quesry (by this or any other method) is not carried over to the table in excel. Do you know of and fixes for this bug?

Hello sir, how to download ISMAIL'S Utilities.

Can you share the file? Thanks!

Can you share the file? Thanks!

When I read the title of your video, I thought you will show us how to extract a URL from a cell in Excel containing a hyperlink. Any lead for that ?

Thanks Bhai !!!

Great tutorial 👌. Subscribed

Thank you❤️

Is it possible to make these macros work from the Personal Macro Workbook?

Very helpful video . Please make videos in Bangla.

Thank you for this tutorial!

धन्यवाद ❤️

Well presented

Great video. I wasn’t aware of the implements function and it seems like it’s the best way to keep coding “clean” and readable. Can you tell me what you’re doing when you click on Rubberduck? I’m not familiar with that function.

Thank you so much for an explanation and a cool example of interface in Excel. Get subscribed!

Thank you!

I've never seen it explained so easily. thank you But I think there is one more thing I need to learn. I copied and pasted the code into the file exactly like the teacher's code, but... EventDriver module Set CurrentPerson = Person.Create("Md.Ismail Name", 27) The above code does not recognize Person. An error message appears saying the variable is not defined. so... Dim CurrentPerson As New Person Set CurrentPerson = CurrentPerson.Create("Md.Ismail Name", 27) After modifying it like this, it works fine. What's the problem? If you download the teacher's file and run it, it will work. At that place... Dim CurrentPerson As Person Set CurrentPerson = Person.Create("Md.Ismail Name", 27) This is what happened and it worked well. '@PredeclaredId Is there something else that needs to be set in the VB editor to use this?

How to generate the combination table automatically?

Thank you Ismail! I'm in love with VBA as you are. What kind of job do you have? Im wondering, because I would love to be a full time VBA developer, but dont see where those skills are required. Its such a shame to have digged to the very bottom of VBA knowledge and not be able to apply this in real world job

Thank you very much for great content! And I want to point out that this particular example in this video is a great example of how you Can use interfaces to bypass the VBA limitation of not being able to pass function pointer to another function! I was thinking about it too - If you want to pass a particular function in order for it to do certain stuff in another function you just create interface and multiple classes that represent various functionality! And another idea for your next video - is you Can show how you Can create classes with default instance of the class, so you wont have to New up instances all the time. For this particular example, where you use a class as a function this would be quite useful! And in the end, If a class doesn't hold any state of its own, using default instance of the class without having to do "New" all the time seems reasonable

very very useful, more please !

Nice video.. I have a shared folder with size of close to 500 gb it contains multiple subfolders and files. How to find out top 20 big file/folder which consuming space along with lanid or details of who created it

Most of VBA users don’t even know that they can code in OOP manners with VBA as you do in this video. Your channel definitely deserves millions of subscribes.

Classes always hardest part of vba. Hope u make more vid like this one. Nice job man.

Cool to see another video out on the web about Selenium Basic! If you're interested, I also created one recently. I talked about all the set-up behind getting Selenium Basic up and running, some basics about "Xpaths" as well as how to run some Javascript code. czcams.com/video/dwRDzRZGx2o/video.html ^link above

Hey. Great job. Could you share file with code that you mentioned ?

Bhai Thank you ... Bhalo lagse tumar process ta. Eid Mubarak!!! Enjoy your day! Subscribe koira disi.

File Link not working

for ur PrintBonus sub 8:09 the Emp argument could be a variant datatype and it would work aswell. so why should i do all that implementation stuff if i just could use a variant datatype variable ? would work in each situation aswell ?

Thanjs so much. But This connection dosen't work if we work on sharepoint. Can you please help me for that. Thnks

thank you

Hi, friend! Tell me how did you customize your VBE ?

thanks Bro!

Thank you Ismail

Thank you for sharing your knowledge. It's been excellent. However, I am unable to access the file link provided. Could you please check the accessibility or share an alternative method to access the file?

What do I have to do to froze the header row (not to be scrolled)?

Well presented thank you done subscribe

That was a weird issue on Power Query! It worked very well. Thanks for this video.

oi, tudo bem? tentei fazer mas estar dando o seguinte erro: erro vba o tipo definido pelo usuário não foi definido, nessa linha do código: Implements IControlEvents. uso office 2016 32 bits e o windows 10 64 bits

Hello! Very hepfull video !! Can you sent us and the pdf with the notes?

Well Explained, I just subscribed to your channel

Thanks bro................ i request first teach this all in module level and then go to class level for better understand........... ok .........but.... overall thank for something new..

give some real world examples for easy understanding .............. sorry !!! now this is bouncing of my mind