VB.NET - VBA Code Drag and Drop!

With this tool you can pull VBA code by drag and drop from the application in an Office document, either into the document or into the VBA editor. The program is self-describing. The VBA code is read from text files, which are in a subfolder of the application. If a file with same name is found plus ending “.faq”, assistance can be spent over this file. Example: File is called "Sample.txt" - help file is called then "Sample.txt.faq". The text and help files are in subfolders like applications are called (e. g. Excel, Word…). If you maintain the structure, the program can be easily extended. In irregular distances I extend the program and add new codes in Excel. In the other Tabs there is only one example - now it is your turn. If you minimize the program, it is put down in the System tray and with one click again indicated. You must have installed the .NET Framework on the computer. The file at the end of the article is a MSI setupfile.

ExVBADragDropSetup.msi MSI Setup


  1. Hello Ralf...

    very nice Tool; I tested it and it works fine:-)

    One suggestion please: can you create separate english and german versions?
    I think, it's a lttle bit confusing when reading help texts in englich and german.

    Bye, Maninweb

  2. Hi Maninweb, :-)

    that is a very good idea and on weekend I will compile two versions.

    Thanks for your suggestion.

    By, Ralf

  3. do you have a vb.net to VBA converter ?

  4. Not really. If you liked to program in .NET for Office, then look in Google for VSTO.


Formeln auf einer UserForm in einer TextBox darstellen...

Formeln auf einer UserForm in einer TextBox anzeigen. Z. B. "Formula", "FormulaLocal"... und wie muss die Formel in VBA ...