VBA Codes Mania-EN

Here, you can,

Perform unique actions and options through the Codes published on this page. The Codes have been designed with great care and patience. Subsequently, they have been successfully tested. We have chosen the simplest and most effective ways to design them, and the page is gradually being updated. It is therefore dynamic and evolving,

Adjust Form Size to the current screen (Without loss of quality) (Watch the video)

Adjust Form Size to match screen dimensions (Watch the video)

Display a Scrolling Title/Message (Marquee Text) in a UserForm (Color Selection)(Watch the Video)

Import multiple Worksheets (from multiple Workbooks) into the current Workbook (Watch the video)

Set the Application to Full Screen (Watch the video)

Restore the Application to Default Size (Watch the video)

Hide the Formula Bar (Watch the video)

Reveal the Formula Bar (Watch the video)

Disable the “X” button on the UserForm (Watch the Video)

Hide the UserForm’s Address Bar (Watch the Video)

Move the UserForm with mouse movement (Watch the Video)

Create a Progress Bar (Watch the Video)

Make the UserForm Transparent (Watch the video)

Start the application on computer startup (Watch the video)

Run a command after a delay (Format “HH:MM:SS”) (Watch the video)

Send the Payslip (as a PDF Attachment) via Email to each Employee (Watch the Video)

Select a File (Any format) and Send it via Email (Watch the Video)

Create an .EXE Executable file for your Application (For Visual Basic 6.0) (Watch the Video)

Convert a VBA application into a standalone application (OpenSource external tool) (Watch the Video)

Simply, insert the requested value in the box, click on the “Get the Code” button and Hop, the code appears in the square at the very bottom of the page… copy and paste it into your UserForm…That’s it 🙂



Adjust Form Size to the current screen (Without loss of quality)


Adjust Form Size to match screen dimensions


Afficher un Titre/Massage Défilant (Texte Marquee)






Import multiple Worksheets (from multiple Workbooks) into the current Workbook


Set the Application to Full Screen


Restore the Application to Default Size


Hide the Formula Bar


Reveal the Formula Bar


Disable the “X” button on the UserForm


Hide the UserForm’s Address Bar


Move the UserForm with mouse movement




Create a Progress Bar








Make the UserForm Transparent


Start the application on computer startup


Run a command after a delay




Send the Payslip (as a PDF Attachment) via Email to each Employee in

Insert the General Data






Insert the Names of the Cells in the template sheet. They receive Data from Columns A, B, C, etc., in the DataBase.




Insert Data regarding the PDF and the Email to send.






Select a File (Any format) and Send it via Email






Créer un fichier .EXE Exécutable pour votre Application
Insert the FULL NAME of your Application: