Just wondering if any one has found value added in writing VBA code using NotePad++? If all the bells and whistles that platform has, if it offers any benefits over or with the VBE?
Just wondering if any one has found value added in writing VBA code using NotePad++? If all the bells and whistles that platform has, if it offers any benefits over or with the VBE?
Why would you code in notepad for VBA. You can't test code there
And, as far as i know, it won't auto-complete object properties and methods. You cant compile the code. You can't run the code. What can you suggest in favour of using NotePad++?
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
NP++ is essentially a glorified text editor. In an Excel context I use it for ribbon xml. It formats that nicely.
I can't see any advantage for VBA as, in addition to the previous comments, there is no intellisense, object browser, debugging tools, immediate/locals window etc, or module structure.
Thanks for the responses... confirming what I believed to be the case... I had run across NP++ adulation that made it sound as though I was missing something glaring. Not that the VBE is ideal, but with enough personalized tools its usable...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks