Over the past few months the VBA IDE window has been opening in a very small compact window. It is happening to other developers in my company.

I am using Office 365 (16.0.10730.20264) 32-bit

By default each procedure should only have the first procedure line (header) visible with an expand button to show all lines within the procedure. Currently a lot of time is spend scrolling through code.

I would also like to see the two drop downs for general and declarations changed to a tree view on the left so that I can more easily navigate procedures and methods.

VBA editor allows to undo only the last 20 steps. That feels like programming in 1980s. I don't think there is any reason not to raise this number, this particular improvement should be a TOP PRIORITY for the team.

It would be great if the VBA IDE would highlight...

(a) The start and of Blocks such as If/End If. So if you highlighted the "If" the matching "End If" would also be highlighted. This would be great for both coding but also auditing inherited code.

(b) Highlight incomplete Blocks: so if you start "If" it's red until such time the closing "End If" is added

Hi,

I have been using Microsoft Bookings for a while until last year it suddenly was disabled for my account.
I was using the outlook.office.com/owa/?path=/bookings/ url to access Bookings but are no longer able to.

Also the "Business Apps (Free)" are not available for my E3 Developer subscription, but they are for the normal E3 which is weird.

It would be great if Bookings or the Business Apps (Free) could be enabled for the E3 Developer subscription.

Thanks!

Access can link to SQL Server tables but it would great if it had the same intellisense that SQL Server has for writing SQL Statements directly into the VBA IDE. So if you referred to a linked (or local) table in your VBA code then typed the period, intellisense would show the available fields.

Office 365 has monthly versions (such as 1803, 1810, etc.). This version is displayed in the Office client application's Account tab.

I couldn't find a way to programmatically get this Version number on the client side. There is only the usual full build number.

Is there a way or can a way be provided, please?

Line numbering is essential for efficient error trapping. It would be great if the VBA had line numbering by default. To be effective, it should...

(a) automatically renumber when code is edited
(b) be able to be toggled between show/hide

... use data of changes made on a document and time spent on it to make the user sure not to mistakenly close the doc without saving it.
This may happen when the open docs are so similar in content and everything, as happened for myself and 2hours effort disappeared. For example you can ask twice if the user is sure to close the doc without saving it.

I work in VBA alot at work and would be great to create repositories of VBA Code for editing from multiple machines and environments and tracking changes to Modules and classes. I don't get to use more advanced IDE's because of licensing issues and IA Security.

This is for developing Access Databases and should be part of the Database Tools: One thing about developing Access Database or any database in that manner is the need to interview workers and analyze current work functions as part of database planning ... I think there needs to be some sort of automated questions document forms and other sheets to help organize and plan the database.

I can see there are some database tools such as Analyze tables and database Documenter but those doesn't help much before the databases are developed.

I would like to be able to link from ACCESS applications to EXCEL Sheets and from EXCEL applications to ACCESS tables. Of course using VBA.
Probably too much to ask.

I was just helped with my issue. I have an Office 2013 H&B that was updated on 8 january. Since I received the error except in Outlook.
I use Bitdefender as an antivirus.
There is an issue between both applications. I can keep running Bitdefender (Total Security 2019) but I need to deactivate "Advanced Threat Defense". When that is down everything works.
Now it's patience till another update comes.

Please find a way to enter and display UTF-8 or UTF-16 strings (or at least UCS-2 (aka "Basic Multilingual Plane"))(Codepage 65001 or 1200) in the VBA Editor and in VBA-Functions like MsgBox().

I think the color coding of the Office VBA IDE could be improved to match, say, that of NoteBook++.

If you copy your VBA code into NoteBook++ (and select Language: Visual Basic) you'll see improved color coding compared to the current VBA IDE. For example:

(a)Line Numbers are red
(b)The colors are easier to see (more contrast) and customizable
(c) Characters between parentheses are red e.g. Me.lstContacts.Column(20) where the 20 is shown in red
(d) If you highlight text with the mouse, other occurences of the same text are highlighted on the page
(e) string characters between quotes are grey

ability to create a range for printing (like in excel 2011)
ie: cells to be printed by the macro.