Hey all, I was just wondering if there are any other vba editors available? The built in one is annoying me, there are some simple code formatting things that other editors I have used can do that makes editing code that much easier..
VBA editor
- Thread starter Zaeed
- Start date
One thing that I would bend over backwards for is the ability to 'minimize' subs. by this i mean a + button next to the sub declaration that when clicked minimized that sub to one line. This would make things so much easier to navigate long form codes..
Another thing, i don't know if this is just simply something wrong with the computer i'm working on, but the code pane will not scroll using the mouse scroll wheel.. the Project Explorer on the left scrolls horizontally using the mouse wheel but the code window is unaffected.. most annoying..
They are simple things, but they are bugging me..
Another thing, i don't know if this is just simply something wrong with the computer i'm working on, but the code pane will not scroll using the mouse scroll wheel.. the Project Explorer on the left scrolls horizontally using the mouse wheel but the code window is unaffected.. most annoying..
They are simple things, but they are bugging me..
boblarson
Smeghead
- Local time
- Today, 03:01
- Joined
- Jan 12, 2001
- Messages
- 32,040
Well, I can't give you everything but I can give you some suggestions on how to make it a little easier.
1. As for the scroll - download this and use it (I did and I even sent money to the developer because I found it so useful):
http://www.gasanov.net/VBScroll.asp
2. Can't make the code compress down but if you use the two combo boxes in the VBA window you can select right to the function or sub you want.
3. If you aren't using MZ-Tools, consider getting them (they're free) as there are a ton of good utilities from adding custom error handlers, line numbers, and a ton more.
http://www.mztools.com/index.aspx
4. And I also use Smart Indenter (another free tool) so I don't have to do it manually. You can indent a procedure, a module, or even the entire project, all with the click of a menu item.
http://www.oaltd.co.uk/Indenter/Default.htm
1. As for the scroll - download this and use it (I did and I even sent money to the developer because I found it so useful):
http://www.gasanov.net/VBScroll.asp
2. Can't make the code compress down but if you use the two combo boxes in the VBA window you can select right to the function or sub you want.
3. If you aren't using MZ-Tools, consider getting them (they're free) as there are a ton of good utilities from adding custom error handlers, line numbers, and a ton more.
http://www.mztools.com/index.aspx
4. And I also use Smart Indenter (another free tool) so I don't have to do it manually. You can indent a procedure, a module, or even the entire project, all with the click of a menu item.
http://www.oaltd.co.uk/Indenter/Default.htm
oooo.. line numbers was the other thing... forgot about that... IMO thats the dumbest thing MS did. As if leave out line numbers..
as for the code compression.. using the combo boxes is what i've been doing, but i don't like it.. When coding in java i use JCreator which has this function and it makes things so easy.
thanks for those links bob, ill be getting them for sure..
as for the code compression.. using the combo boxes is what i've been doing, but i don't like it.. When coding in java i use JCreator which has this function and it makes things so easy.
thanks for those links bob, ill be getting them for sure..
