วีดีโอ

Hello. Glad you liked it. It's the first project I worked on I think. Here is the code for reference but I should rewrite it. github.com/alexofrhodes/EXCEL-GAME-Go-Baduk-WeiQi

Hi, I just saw your message. I'll try this week to find where I had it and fix the link, I'll let you know.

@@anastasioualex Não tem o arquivo no link Mestre

@@klebersonmoreira1821 I will fix it

github.com/alexofrhodes/VBA-VBIDE-Extensibility/tree/main look at uProjectExplorer.frm

@@anastasioualex Tanks 🤛🤝

Hi, what are you doing exactly that would need automation? What are the limitations you mentioned? You can email me instead of chatting from the comments at anastasioualex@gmail.com

You're welcome! I use it all the time 😁

@@anastasioualex If you know about other good and useful shell extensions, please share. I'm always on the hunt for useful stuff.

Thank you 🙂

Hi Philong, thanks for your continued and valuable suggestions. Both are good ideas and I will try to implement them within this week.

You're welcome!

Hi! I'm glad you like it. Last I remember, I had this code in the aDesigner class, is that correct? I removed it in favour of the aMultipage class, where I have a better menu builder th-cam.com/video/O8ZDGW06z_I/w-d-xo.html The reason being that in the multi page you can view each page separately as you add controls, while with the previous frame approach everything was cramped. I will put the code back to the aDesigner class and you can find it updated later today or tomorrow here: github.com/alexofrhodes/VBA-Library/tree/main/CLASSES Are you using any of my tools? Any feedback is really useful! Thanks.

@@anastasioualex Hi, I'm looking into your tools rn to see what I want to use and make my life easier I will provide feedback later

actually it's a mess to separate some things to provide as standalones, as they are interconnected. you can have a look at the file where i develop VBE and Objects mods at github.com/alexofrhodes/VBA-Projects/tree/main/Addins/DEV%20Tools . The userforms named like "Z_*" have some examples. The Z_Multipage covers the menu building. Ask me anything if you need an explanation or custom request. Will push an update for DevTools, probably tomorrow, including a Radial Menu, stay tuned. Thanks.

@@anastasioualex will do, thanks for the work

i'll try to keep the minimum code required to make the Multipage Menu Builder into a standalone, but i'm a bit busy at the moment. if you are looking to make things easier that would be 1. creating custom macros 2. making them accessible from ribbon or right cilck menus or 3. userforms. What are you working on?

Thank you very much for your support! Haven't made much community building so I don't get any feedback, I don't even know if anyone's used anything 😅 Should make a discord or something.. Keep feedback and suggestions coming and I'll do my best 💪 Kudos to Petr and Gokmen.

I have a class named aListbox here github.com/alexofrhodes/VBA-Library/tree/main/CLASSES Dim alb as aListbox Set alb=new aListbox alb.init(listbox1) alb.autoFitColumns In the user form of the video it is not a listbox but a listview. Exactly the same steps above but use aListview class.

There's no better date picker than yours 😁 just modified it so that when it opens, if you click ok it will take today as selected date. To do: close form if user presses escape.

response th-cam.com/video/DNFtbvaugAE/w-d-xo.html

Hey Ben, glad you joined! I'm using AutoHotkey instead, I made a video response th-cam.com/video/55E3IRR6wF8/w-d-xo.html

@@anastasioualex This is amazing, thank you. 🙏⚡

Sure, thanks for feedback.

greetings! I had stopped developing the word addin and forgot to put the work so far in a repo, thanks for reminding me :P here is the link to the .docm file, google how to save it as a word addin if needed. Also note that I move things around every now and then, I try to keep a file with the folder structure in my github main page. If you don't find something or have any feedback, suggestion or request you can message me through github or by email at anastasioualex@gmail.com link: github.com/alexofrhodes/VBA-Projects/tree/main/Addins/Word%20Addin

Hi. Thanks for reaching out. You can find the github link to the file and source code in the video description. I developed it as part of my dev-tools where i'm mainly learning about classes, testing and creating things about the VBE such as modules, procedures and userform objects. At the moment it has not been extracted as a standalone feature. You can open the dev-tools.xlsm and have a look at the multipage userform and class. After going through the code, let me know if you need any help with it and I'm always grateful for any feedback or suggestion.

@@anastasioualex grateful to you

Actually get my aMultipage class here github.com/alexofrhodes/VBA-Library/tree/main/CLASSES and then in user form with 1 multipage and optionally 2 side bars named SidebarRight and SidebarBittom (I leave it to user because they were intended to be filled manually, but I'm thinking to automate it) Dim amp as aMultipage Set amp =new aMultipage Amp.init(multipage1) Amp.buildmenu

😁 feedback always appreciated

I think I should modify this to work with multi page control instead of frames

Hi. Try here github.com/alexofrhodes/VBA-Projects/tree/main/Addins/FormBuilder and let me know if it works for you

github.com/alexofrhodes/VBA-Projects/tree/main/Addins/Immediate%20Windows

Did it work for you?

Hi! I reordered my repositories so some things were misplaced. Thanks for reporting it! You can find it at github.com/alexofrhodes/vbArc-StandAlone/tree/main/Modern-Userform-Todar

Hello Pramod, UI automation is a very interesting topic and VBA has access to it, but I've found only few sources on VBA x UIA. I'll see if I can find anything to share on the topic, but let's start by asking what you want to achieve and if vba is absolutely necessary or if some other tools for the job. You can also contact me directly at anastasioualex@gmail.com or find me on Facebook (facebook.com/profile.php?id=100065068627996) or VK (vk.com/alexofrhodes)

Hello Mark, thanks for joining! All my addins are free and unlocked for everyone to use and learn from, you can find them at github.com/alexofrhodes/vbArc-addins. If you use any of my addins it will create or add its contents to the vbArc tab. Here are instructions for how to put addins in the addins folder www.contextures.com/exceladdins.html. Keep in touch, report bugs, and i'm open to suggestions or requests :) Alex

Thanks, keep up :)

Hello Frank, thank you very much for your support! I'm glad you like the content. If there is interest I can make tutorials. Let me know if you have any suggestion or question.

Thank you! Here is the modern userform author's GitHub for more interesting stuff github.com/todar

@@anastasioualex thanks buddy

You're welcome!

thank you. have a look at vbaTools if they got what you need github.com/vbatools/MacroToolsVBA

Visual Basic for Applications (VBA) is an implementation of Microsoft's Event-Driven Programming language Visual Basic 6.0 built into most desktop Microsoft Office applications.

You're welcome!

Thank you so much Ajay, I'm saving your comment! Mail me at " anastasioualex at gmail dot com " and I'll see how I can help. A friend has worked on something like this.

Hello Ajay. Have you worked on that yet?

@@anastasioualex I still do watch your contents :) they are good as before. For "Page setup Manager" i found a free addin that does the work. If you want to take a look at it, i would be happy to email you.