+ Reply to Thread
Results 1 to 5 of 5

Anyone using Notepad++ and VBA for coding

  1. #1
    Registered User
    Join Date
    01-08-2013
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    4

    Question Anyone using Notepad++ and VBA for coding

    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?

  2. #2
    Forum Expert
    Join Date
    10-11-2021
    Location
    Netherlands
    MS-Off Ver
    365
    Posts
    1,386

    Re: Anyone using Notepad++ and VBA for coding

    Why would you code in notepad for VBA. You can't test code there

  3. #3
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,446

    Re: Anyone using Notepad++ and VBA for coding

    And, as far as i know, it won't auto-complete object properties and methods. You can’t 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


  4. #4
    Forum Expert
    Join Date
    07-23-2018
    Location
    UK
    MS-Off Ver
    O365 32bit (Windows)
    Posts
    1,980

    Re: Anyone using Notepad++ and VBA for coding

    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.

  5. #5
    Registered User
    Join Date
    01-08-2013
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Anyone using Notepad++ and VBA for coding

    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...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Macro-Launch Notepad from Excel and save data in notepad and save with naming conventio
    By hjaspaul in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-01-2016, 09:19 PM
  2. [SOLVED] In need of help regarding combo box coding and button coding (Access form project)
    By mailblade in forum Access Tables & Databases
    Replies: 2
    Last Post: 01-09-2016, 01:34 AM
  3. [SOLVED] Save Notepad through VBA Macro, having Copied Range of Cells, Pasted into notepad
    By analystbank in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 12-22-2014, 02:14 AM
  4. Opening Notepad a saved notepad file and copying the data on it
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-20-2014, 06:18 PM
  5. [SOLVED] Notepad to excel and back to notepad
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-27-2014, 10:33 AM
  6. Remove marching ants after notepad macro opens notepad
    By swade730 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-07-2014, 09:47 PM
  7. how to copy selected notepad text and paste it in other notepad with macro
    By Guru232 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 04-24-2013, 04:43 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1