Тёмный

VBA Code Generator - Dynamically construct code on runtime. Custom VBE menu control 

VBA A2Z
Подписаться 51 тыс.
Просмотров 10 тыс.
50% 1

Advanced VBA to automatically generate and insert codes in VBE Module.
Please like, share and comment to improve channel algorithm
👉 Subscribe to receive our latest content ru-vid.com?sub_confirm...
Useful Ready to use VBA Functions: vbaa2z.blogspot.com/2021/04/u...
You can now support by buying any of the Projects or Source Code.
📥Downloads: pamaitech.com/downloads/
👍 Support: paypal.me/pamaitech
✉️ Contact: contact@pamaitech.com
📌What to watch next:
Playlist: ru-vid.complaylists
Videos: ru-vid.comvideos
#VbaA2z

Наука

Опубликовано:

 

17 фев 2021

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 72   
@bolsiuswesley
@bolsiuswesley 3 года назад
Thank you very much, I am already looking forward to the next video on this topic
@VBAA2Z
@VBAA2Z 3 года назад
You are most welcome. thanks for watching.
@wildmagic520
@wildmagic520 2 года назад
Thank you so much for this video. Been developing many projects for my department and have done a lot of repetitious copying pasting modifying blocks of code. Started researching how write code to write code. Your strategy for making this possible by showing us how to create custom controls to insert blocks of code is just what I needed. Perfect! Appreciate your work and clear explanations. You sir are a VBA guru. Checked out your website and definitely considering buying some of your projects & source code. Please continue doing what your doing and looking forward to all of your videos.God Bless🙏
@VBAA2Z
@VBAA2Z 2 года назад
Thank your your kind words. More to come... God bless
@dovacmarlon7493
@dovacmarlon7493 3 года назад
Great tutorial... Your insights in vba is really remarkable.
@VBAA2Z
@VBAA2Z 3 года назад
Glad to hear that! thanks a lot.
@silunewmai9017
@silunewmai9017 3 года назад
Nice collection you've there. Great job, keep it up
@VBAA2Z
@VBAA2Z 3 года назад
Thanks, will do!
@holieh5301
@holieh5301 3 года назад
Awesome! Thanks for another timesaver.
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome. thanks for watching
@kinga334
@kinga334 3 года назад
Nice tips and tricks. Never knew there was short hand for variables. Thanks a lot
@VBAA2Z
@VBAA2Z 3 года назад
You are most welcome. thanks for watching.
@nicor1501
@nicor1501 Год назад
Very very instructive ! Thanks a lot for sharing it. looking forward to see more like this one on MSaccess
@VBAA2Z
@VBAA2Z Год назад
Glad you liked it! More to come!
@nicor1501
@nicor1501 Год назад
@@VBAA2Z can't wait to watch any videos on MSaccess too😀
@kingqiabonmai1890
@kingqiabonmai1890 3 года назад
This and prior video helped me in my daily work. Thank you soo much
@VBAA2Z
@VBAA2Z 3 года назад
You're very welcome!
@perymdiso1006
@perymdiso1006 3 года назад
Another great tut📺
@VBAA2Z
@VBAA2Z 3 года назад
Thank you! Cheers!
@shellynomis7368
@shellynomis7368 3 года назад
I found your videos really helpful. thank you.
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome. thanks for watching
@SaraPerzYT
@SaraPerzYT 3 года назад
Another brilliant utility. Thanks a lot
@VBAA2Z
@VBAA2Z 3 года назад
You are most welcome. thanks for watching.
@user-uq1cn6ul7l
@user-uq1cn6ul7l 11 месяцев назад
Another amazing video, thanks a million Sir.
@VBAA2Z
@VBAA2Z 11 месяцев назад
Glad you enjoyed it
@lchewang9114
@lchewang9114 3 года назад
Thanks sir for simplified video. 🙏
@VBAA2Z
@VBAA2Z 3 года назад
Most welcome. thanks for watching.
@kiloonzjico7953
@kiloonzjico7953 3 года назад
Thanks for sharing your knowledge. Excellent tool
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome. thanks for watching
@jeraldmonsales8955
@jeraldmonsales8955 3 года назад
Your deep understanding with VBA is unbelievable! Been supporting for a long time. Sir may I know if there are resources/books you can suggest which covers advanced topics about VBA, just like this?
@VBAA2Z
@VBAA2Z 3 года назад
Jerald, thanks for your support - it means a lot. I have not come across books covering out of box functionalities like this. It naturally comes with experience and high demand
@jeraldmonsales8955
@jeraldmonsales8955 3 года назад
Amazing, i see. Nonetheless, thank you for the response, i hope you keep making videos like this sir. Looking forward for your upcoming videos, Godbless 🙏
@VBAA2Z
@VBAA2Z 3 года назад
Thanks and God bless. 🙏
@arikurita401
@arikurita401 3 года назад
Excellent tutorial - thank you
@VBAA2Z
@VBAA2Z 3 года назад
You are most welcome. thanks for watching.
@GiselleBrat
@GiselleBrat Год назад
great videos i just keep loving it
@VBAA2Z
@VBAA2Z Год назад
Thanks, will do!
@Rahul-sn1wn
@Rahul-sn1wn 3 года назад
Thank you my friend. Very informative
@VBAA2Z
@VBAA2Z 3 года назад
You are most welcome. thanks for watching.
@pbassociates9168
@pbassociates9168 3 года назад
Very informative video... Thank you
@VBAA2Z
@VBAA2Z 3 года назад
You're welcome. thanks for watching.
@scottymars3289
@scottymars3289 3 года назад
Excellent!
@VBAA2Z
@VBAA2Z 3 года назад
Thanks
@scottansir7708
@scottansir7708 3 года назад
loved your unique contents keep it up.
@VBAA2Z
@VBAA2Z 3 года назад
Thanks, will do!
@user-ll8up1eu4d
@user-ll8up1eu4d Год назад
You are super Sir, Thank you.
@VBAA2Z
@VBAA2Z Год назад
You are most welcome
@ManishKumar-qj7sq
@ManishKumar-qj7sq 3 года назад
Awesome sir
@VBAA2Z
@VBAA2Z 3 года назад
Thanks Manish!
@rahulshewale9206
@rahulshewale9206 3 года назад
Thank you so much
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome. thanks for watching
@benjaminf5731
@benjaminf5731 Год назад
thanks a lot
@VBAA2Z
@VBAA2Z Год назад
You are most welcome
@susilsxzen-ff1zn
@susilsxzen-ff1zn Год назад
Thanks
@VBAA2Z
@VBAA2Z Год назад
most welcome
@yasserelbighily6983
@yasserelbighily6983 6 месяцев назад
Nice video, however if you have many functions that you call by the menu buttons by running the calling procedure that initiate the menu how you deal with multi calls, assuming you have function A and B, once the menu initiated both functions are available once you click one of them the both will not be availeble for the next click and i should run the menu calling procedure again to invok to the next click itest that many times with the same result, how can we avoid that
@hoseal8048
@hoseal8048 3 года назад
Thanks for this amazing tutorial. How can I clean/delete control added to menu and insert.
@VBAA2Z
@VBAA2Z 3 года назад
You're most welcome. thanks for watching. You can replicate the block of code and delete by finding the tag
@ravisharma2790
@ravisharma2790 3 года назад
Can you suggest any course on VBA from scratch to advanced level including debugging for automation in
@VBAA2Z
@VBAA2Z 3 года назад
Below is the practical VBA Programming course. If you have specific questions comment or feel free to email (in video description) ru-vid.com/group/PLo0aMPtFIFDocT-bLo37Fj_iwenKtUlKr
@atingnewmai3680
@atingnewmai3680 3 года назад
👍
@VBAA2Z
@VBAA2Z 3 года назад
Thanks Ating! 🙏
@bogach
@bogach 2 года назад
I had seen a similar example somewhere before and liked it very much. but the problem is that when I click on that button for the second time, I cannot add anything to vbe again. The button is blankly cliking and I couldn't find the reason. :( (note: If I use a procedure that contains like: msgbox "helloworld" ; it works all the time. but as far as I understand, when I try to add something to vbe it only works once.
@VBAA2Z
@VBAA2Z 2 года назад
You can add class handler for that.
@plop1981
@plop1981 2 года назад
@@VBAA2Z Hi Thx for this very useful work ....:) Like bogach said i can just click once on the button for insert code and the second time nothing happen. You said "you can add a class handler", would you give us an example because i don't really understand what it means ? Thx and again very good job
@a.salvaripoll2765
@a.salvaripoll2765 Год назад
I have the same problem, I do the code in MSAccess; the first time the code is inserted, but the second fails. You said "you can add a class handler", pleas, can you explain me what do you mean? I ask for your patient if my English knowledge is not so good, as it's not my mother language. Best regards from Spain, and thanks in advance for your answer. Alba.
@davidwebchile
@davidwebchile 5 месяцев назад
How to create VBE addins? With C++? 🤔
@plop1981
@plop1981 Год назад
Hello Thanks for this very useful tutorial I have question : when i run the Create_CustomCtrl procedure for the first time my button is create and the when i clic on it everything is ok (the code pasted correctly) but when i clic a second time nothing happend, i should run the Create_CustomCtrl procedure again. Did you have a solution for this problem ? Thank you
@VBAA2Z
@VBAA2Z Год назад
Are you using the class object?
@plop1981
@plop1981 Год назад
Yes i use le cVBE class Module
@ravisharma2790
@ravisharma2790 3 года назад
Fees for the same .
@VBAA2Z
@VBAA2Z 3 года назад
replied in another comment.
Далее
How to use Custom Types To Write Ultra Fast VBA code
12:51
Советы на всё лето 4 @postworkllc
00:23
5 VBA Hacks Everyone Should Know in 2021
11:20
Просмотров 90 тыс.
How to Use Arrays Instead of Ranges in Excel VBA
10:20
Просмотров 197 тыс.
PHP doesn't suck (anymore)
10:48
Просмотров 202 тыс.
Wise Owl Answers - How do I unzip files using VBA?
13:25
The Clever Way to Count Tanks - Numberphile
16:45
Просмотров 746 тыс.
iPhone socket cleaning #Fixit
0:30
Просмотров 18 млн