By using vba.booksticle.com you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes

948 Steps to 6 Figures by Learning Excel-VBA and Other Skills



Step 88 - Hello World!


The VB Editor is where you will enter a VBA Code.

You can either:
  • Record a Macro
  • Import code as a module
  • Search for code, copy and paste in
  • type your code.

    There are typically 4 Windows you will use
  • Code Window
  • Immediate Window
  • Project Explorer
  • Properties Window

    Let's write some VBA Code!

    Editor
    1. Open a new Excel WorkBook aka an Excel file
    2. Press Alt F11 or Developer > Visual Basic to go to the Editor
    3. Editor has an old style Windows menu and not a ribbon at the top
    4. Below that are a toolbox of icons
    5. Leftmost one will switch you to Excel
    6. View > Code opens a Coding windows where you can enter your VBA or Macro statements
    7. There are two drop-down or combo-boxes at the top. The right one is the Procedure drop-down and the left one is the Object drop-down

    8. Set the following options
      • Tools > Options

    9. Enter your first program
      Click the code window start typing type following:

      Sub HelloWorld()
         msgbox "Hello world"
      End sub


    10. Press the Play button or F5 to run the code.
    11. The Hello World Message box displays



    •    Table of Contents | Send us your feedback | © 2025 All Rights Reserved | Edit