117 votesUnder review · 6 comments · Feature Requests and Feedback » Office Developer Tools · Flag idea as inappropriate… · Admin →Svet Dimov commented
Be nice to be able to do:
Similar with Field(“_see drop down of all field names, same with other objects like QueryDefs, TableDefs, etc.
Close If, Select, With statements automatically
Create a generic error handler when hitting enter after creating a function
Easier interface to change colors, fonts, etc. as opposed to one by one drop downs and be able to save as “theme”
429 votesUnder review · 24 comments · Feature Requests and Feedback » Office Developer Tools · Flag idea as inappropriate… · Admin →Svet Dimov commented
This is a very valid suggestion and I am not sure when and who declared VBA and all its underlying MS Office to be outdated when all investment banks use Microsoft from analyst to managing director and these are the entities that actually have the moneys to pay for quality, professional rapid/tactical VBA application development if it weren’t for all the noise of all recent technologies and languages. And more often than not the fancy, robust, strategic, multimillion dollar systems have a button to export to Excel. No matter what R and Python developers say, VBA with Access and Excel will dominate the analytics environment simply because it is the backbone of banks - and they are the ones providing and backing financing from a 200 credit card loan to a multi-billion dollar merger.
The current MS Forms controls with the refreshed color schemes provide an excellent environment for designer grade GUIs.
Refreshing the IDE would be welcome by all VBA enthusiasts and professionals.