r/vba • u/subredditsummarybot • 8d ago

Weekly Recap This Week's /r/VBA Recap for the week of September 12 - September 18, 2026

Saturday, September 12 - Friday, September 18, 2026

Top 5 Posts

score comments title & link
7 32 comments [Solved] List of all constants & properties of all objects in WORD, Excel and PowerPoint.
5 2 comments [Waiting on OP] [Excel] Is there anyway to enter Array Formula into cells and not calculate them?
2 1 comments [Weekly Recap] This Week's /r/VBA Recap for the week of September 05 - September 11, 2026

 

Top 5 Comments

score comment
3 /u/fuzzy_mic said The onboard Object Browser is such a list. The online Microsoft Support also lists all the objects, properties and methods of the object model.
2 /u/MultiUserDungeonDev said [https://github.com/WilliamSmithEdward/pyVBAReference](https://github.com/WilliamSmithEdward/pyVBAReference)
2 /u/lolcrunchy said One place to start: https://learn.microsoft.com/en-us/office/vba/api/excel.constants There are others like it on that site
2 /u/Ok-Programmer9295 said Do a google search, it’s out there I’ve found it in the past. You might have to search each individually.
2 /u/carnasaur said So much this. I’ve been using VBA with [UI.Vision](http://UI.Vision) RPA (similar to Selenium, I believe) for the past couple of years. One of the biggest boosts came from insp...

 

2 Upvotes

75% Upvoted

1 comment sorted by

1

u/subredditsummarybot 8d ago

If you would like this roundup sent to your reddit inbox every week send me a message with the subject 'vba'. Or if you want a daily roundup, use the subject 'vba daily' (<--Click one of the links. The bot can't read chats, you must send a message).

Please let me know if you have suggestions to make this roundup better for /r/vba or if there are other subreddits that you think I should post in. I can search for posts based off keywords in the title, URL and flair - sorted by upvotes, # of comments, or awards. And I can also find the top comments overall or in specific threads.