Best and affordable editor for writing visual Basic code?? – User friendly Tech help

What is your favorite VBS editor to write scripts?
n
If we search vb editor on Google you would find thousand of suggestions like notepad++,vbsedit and many more fancy IDE.But sometimes there are situations, like due to organization compliance policies or some other reasons, that we don’t have access to these editors .Then what to do in that case of scenarios.
n
n“Don’t use a lot where a little will do.” -Proverb
n
nThus we have to achieve maximum out of what we have.
n
nSolution is utilizing the inbuilt feature of developer tab  in  Microsoft excel to code our vbs/vba scripts.
n
nWe thought of sharing the same with you all, follow us on  Fb,G+,Twitter for more updates. 
n
Steps:-
n
1. Open excel instance.
n
n2. Look for “Developer tab” -> Visual Basic
n
n
nNote: – Incase “Developer tab” is not available in the excel ribbon, then, click on Microsoft icon on the top left corner of excel ->Excel Options -> Popular -> check the “Show Developer tab in the ribbon” > OK
nWe can directly launch Visual basic IDE by using ALT+ F11,after launching the excel instance.
n
n3. Right click on VBA project in the “project explorer “ -> Insert -> module
n
n
n
n4. Now we ready to write our code, it provides intellisense and debugging 
n
nn

nfacilities(like we have watch option in UFT same is available here) 
n
n5. Save as type “Excel Macro-Enabled Workbook”
n
n6. Run (F5) or green play icon on the ribbon panel.
nExplore the other features on the panel to learn more.
n
n
n
nPlease share your views or your comments about what can be your favorite editor incase you have limited resources, other than Notepad offcourse 🙂
n
nLearn Vbscript
nSelenium

Was this article helpful?
YesNo

Similar Posts