• Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling
Menu
  • Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling
  • Latest News
    Export Outlook Emails To Excel – VBA Code – 5,700+ Free Downloads
  • Latest News
    Excel To VCF Converter 1.1 – Excel To Vcard – 68,000 Downloads
  • Latest News
    Extract Web Page with Tables – Parse HTML Table – Data Mining Tool
  • Latest News
    Send Mass Email from Excel VBA 1.3 – Multiple Recipients – In Outlook
  • Latest News
    Web Scraping – Extract Data from Website – To Excel VBA
  • Latest News
    VCF To Excel Converter – Open VCF File – Free 28,000+ Downloads
  • Latest News
    Print Screen Automation – Take Screenshot, Save to File and Attach in Excel
  • Latest News
    Excel VBA – Import Data from Another Workbook – Macro to Query Excel
  • Latest News
    How to Telnet from Excel & Autorun Commands
  • Latest News
    Excel VBA – FTP Transfer – Files Download Upload
  • Latest News
    Microsoft Office – Communicator API – Verify Availability Status
  • Latest News
    Excel IP Address Lookup – Bulk GeoIP Lookup
  • Latest News
    Extract URL Links from Sitemap.xml file using Excel
  • Latest News
    Trace Lost Phone – Even Without Internet – Using SMS
  • Latest News
    Universal VCF to Excel and Excel to Vcard Converter
  • Latest News
    Download Facebook Videos – How To Get YouTube Video Downloader?
  • Latest News
    Block Game Requests On Facebook & Candy Crush Invites
  • Latest News
    How to Get stock prices in Excel? – Best Live Stock Ticker
  • Latest News
    How to Get Historical Stock Quotes In Excel – Google Finance
  • Latest News
    JSON Parser – Convert JSON To CSV – Excel VBA Macro
  • Latest News
    How To Screen Record – in IOS, iPhone, Android, Windows, Mac ?
  • Latest News
    How To Remove Duplicate Values in Excel, Google Sheets?
  • Latest News
    Best Bitcoin Trading Platforms – Cryptocurrency Market
  • Latest News
    Lock System at Scheduled Time with Excel
  • Latest News
    How to control Facebook Addiction? & Whatsapp Addcition
  • Latest News
    2018 – Hack Whatsapp Friends – Status Photos
  • Latest News
    Making SORT More Simple and Faster in Excel with Advanced Options
  • Latest News
    WordPress – Recent Posts Widget with Thumbnail – Without Plugins
  • Latest News
    Compare Two Excel Sheets – Highlight Differences – Macro VBA Code
  • Latest News
    Display Related Posts with Thumbnails in WordPress without Plugins
  • Latest News
    Post to Facebook Timeline through Email
  • Latest News
    100 CryptoCurrency Price – Ticker in Excel – Using VBA
  • Latest News
    Engineering Unit Converter Download – Excel Table – Feet To Meters
  • Latest News
    Android ICS File Viewer – Calendar file View in Exce;
  • Latest News
    Download – Backup Facebook Twitter Gplus Linkedin – Data To PC
  • Latest News
    How to remove #n/a in Excel? – Fixing Vlookup #n/a
  • Latest News
    #NoForwardsDay – New WhatsApp Texting Pattern that Would Make You Go Crazy
  • Latest News
    Sudoku Excel Download – Puzzle Solver – Free Game Help
  • Latest News
    Top 4 Whatsapp Tips and Tricks You Didn’t know Existed
  • Latest News
    Mortgage Calculator – Loan EMI Scheduler
  • Latest News
    Learn How To Code JavaScript in VBA
  • Latest News
    How To Open VCF File – Online VCF Viewers – 4 Easy Ways
  • Latest News
    How To Block Unwanted Text Messages in Iphone?
  • Latest News
    How To Scrap A Website Keywords? – Keyword Scraping Excel
  • Latest News
    Login to Facebook, Twitter, Google+ in IE from Excel
  • Latest News
    Excel Instant Messenger – Microsoft Office Communicator API Library
  • Latest News
    Skyrocket Website Traffic With Reddit
  • Latest News
    Excel Games Free Download – 2048 Tile Game
  • Latest News
    How to Speed Up Google Chrome
  • Latest News
    VBA Code – Create Index of Worksheets – with Links to each Sheet

VBA Hello World – Excel Macro – For Beginners

  • Get easy step by step guide to code a Excel Vba hello world program.

    It is perfect place to start Excel Programming for beginners.

    1. Excel VBA “Hello World” Macro Program

    VBA “Hello World” program is so easy just like teaching a kid – ‘A for Apple’.

    Lets see how does the actual code looks like:

    Excel VBA Hello World Macro Code
    Visual Basic
    1
    2
    3
    Private Sub Workbook_Open()
        MsgBox "Excel VBA Hello World Program"
    End Sub


    Program Code Explanation:

    1. Workbook_Open: Excel will execute this code every time You open this Excel Workbook.
    2. Msgbox: Built-in function used to display a Message in a pop-up window.
    3. End sub: Marks the end of the sub procedure.

    It is so easy. Isn’t it.

    Lets see where to write this code in Excel & how to execute.

    Read Also: How to Write Google App Scripts – Hello World Google App Script?

    2. Excel Macro Hello World – VBA Coding Environment

    To write the above code , open a new Excel workbook & follow these steps.

    1. Press Alt+F11 from Excel to view VB editor.
    2. Info Only: On the left hand side panel, there will be options for Sheet1, Sheet2, Sheet3 & Thisworkbook.
      • Inside Thisworkbook – you can write Macro code common for the whole workbook.
      • Inside Sheet1 – You can write code specific to Sheet1.
      • Sheet2 & Sheet3 – same as above step.

    3. Double click “Thisworkbook”.
    4. Copy & Paste above code to empty right side coding area.

    We have complete the coding part.

    Note: Microsoft Office Excel should have installed with VBA option enabled during MS Office Installation. If the below steps did not work, re-install MS Office.

    Also Read: How to Refer Workbooks & Worksheets in Excel Through VBA?

    3. How to Execute the Hello World VBA Code

    Press F5 to execute the code.

    A message box will appear displaying “Hello World VBA Program”.

    Apart from pressing F5, we can run a program using a Command button (or any GUI like button), hyperlink URL, Time triggered Macro etc.,

    Also Read: How To Type Subscript in Excel - Superscript Options - Excel VBA Code

    4. Save File with XLSM (Macro Enabled Workbook)

    Now the important step. Store all the precious work you have learned. Save the workbook with “Macro Enabled Workbook” (XLSM). Close the workbook and open it with macros enabled. The Hello world message box will appear every time the document is opened.

    End of “Hello World” Excel VBA Macro Programing. Now you are familiar with this VBA Alien, what to do next – Get ready to Roam in Space. But be ready to equip with special tips in upcoming posts.

    More Tips: Add a Command Button in Excel Sheet and Assign a Macro

    5. Advantages of Excel Vba Macro

    More interesting facts about Excel VBA Macro over other Programming Languages are:

    Excel has a

    1. Very sophisticated database in the form of worksheets,
    2. Integrated with a VB editor that helps to build code in minutes and
    3. Execute the code without worrying about Compilation,  Build or Linking to EXE etc.,

    These points make Excel macro more sophisticated & a major reason for its long term popularity.

    Though there is a very big debate on whether Excel Macro is dead, I am still making a living with VBA coding knowledge.

    Author: Kumarapush

    Kumarapush has experience in IT industry for 12+ Years including 10 Years in MNC. Has vast expertise in Microsoft Excel automation using VBA Macro. Excel to CSV converter is one of his famous tool that has been downloaded & used by 68,000 users around the globe.

    View all posts by Kumarapush | Website


    Previous Post:
    Next Post: How To Remove Duplicate Values in Excel, Google Sheets?


Post Categories
Popular Posts
Export Outlook Emails To Excel...
Excel To VCF Converter 1.1 –...
Extract Web Page with Tables –...
Send Mass Email from Excel VBA...
VCF To Excel Converter –...
Web Scraping – Extract Data...
Print Screen Automation –...
Excel VBA – Import Data from...
How to Telnet from Excel &...
Excel VBA – FTP Transfer...
Microsoft Office – Communicator...
Excel IP Address Lookup –...
Recent Posts
Enable Insert button in Excel greyed disabled show
Excel Insert Button is Disabled...
Excel VBA Find String in Range Return Row Change Background color Remove Duplicates
Excel VBA - Find String in Range...
Excel VBA Convert Amount in Numbers to Words US Dollar Million Indian Rupee Lakhs Crores finance
Excel VBA Convert - Amount (Numbers)...
Excel VBA Code Get Names of All open workbook path Loop through
Excel VBA - Loop Through All Open...
Name Numerology Lucky Number Calculator Baby names Business name
Name Numerology Calculator - Lucky...
Similar Pages
  • Excel VBA Code Get Names of All open workbook path Loop through
    Excel VBA – Loop Through All...
  • Name Numerology Lucky Number Calculator Baby names Business name
    Name Numerology Calculator –...
  • How To type Subscript in Excel Superscript strikethrough underline font
    How To Type Subscript in Excel –...
  • Excel VBA Merge Cells Unmerge Range Selection objects
    Excel VBA – Merge Cells –...
  • Excel VBA Convert Column Letter Alphabet to Number
    Excel VBA – Convert Column...
  • Excel VBA Convert Column Number to Letter Formula
    Excel VBA – Convert Column...
Popular Tags
  • Email Marketing Block Apps in FaceBook Task Manager print screen VCF HTML Table Import Data Candy Crush Outlook Record Macro android app development SEO Convert URL to IP HTML/ Javascript QR Code Generation VCARD Timer in Excel Countif Google+ bitcoin vba color index vba color codes Data Mining Android social media Twitter bulk email Google Adsense Tips Excel VBA Calendar in Excel Excel Macro WhatsApp Facebook mass email outlook vba Wordpress
FREE Tech Updates

Home

  • Home
  • App Store
    • International Users
    • Indian Users
  • Subscribe
  • About Us
  • Productivity
    • Excel
      • VBA
      • Tiny Tips
    • Android
    • WordPress
  • Social Media
  • Misc
    • Cricket
      • IPL Fixtures
      • VIVO IPL 2016 New Face
      • T20 World Cup
      • Cricket World Cup
    • India Elections
      • How Not To Prepare Yourelf For Polling

Trending Topics

    • Learn How to Access WhatsApp in Web
    • Compare Data In Two Excel Sheets
    • Find IP Address Location – GeoIP Lookup
    • Lock a Folder In Windows Using This Simple Excel Macro Trick
    • Download Free Tool to Convert VCF Contacts to Excel

Join Us

Copyright © 2018 OfficeTricks.com