When working with VBA in Access, Excel, and word the ide automatically spaces what you type.
for Example:
A=10
will be automatically formatted as
A = 10
as soon as you leave the line.
A = 10
Will likewise be returned to
A = 10.
If A< 10 then
becomes
If A < 20 Then
The reason this is important is I frequently do searches for chunks of code and if they are not all formatted the same they won't be found.
Also, it is a great visual cue that the line syntax is correct. If the syntax is wrong it won't format it.
This is a minor grouse from someone who has been programming in VBA way too long.
Keep up the amazing work.
PS I AM still hoping for a switch to turn of Drag and drop editing. I can't tell you how many times I have had to hit the undo key beuscae of that ftureea.
for Example:
A=10
will be automatically formatted as
A = 10
as soon as you leave the line.
A = 10
Will likewise be returned to
A = 10.
If A< 10 then
becomes
If A < 20 Then
The reason this is important is I frequently do searches for chunks of code and if they are not all formatted the same they won't be found.
Also, it is a great visual cue that the line syntax is correct. If the syntax is wrong it won't format it.
This is a minor grouse from someone who has been programming in VBA way too long.
Keep up the amazing work.
PS I AM still hoping for a switch to turn of Drag and drop editing. I can't tell you how many times I have had to hit the undo key beuscae of that ftureea
.
