Excel Macros and VBA For Beginners

Home/Excel VBA/Excel Macros and VBA For Beginners

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


This section is for beginners who have no knowledge of Excel Macros or VBA. By end of this session you will be able to Record and Run a Macro and be able to accept the Inputs from the user and show the Popup Messages.

Please follow the same order as given below, it is easy to learn Excel VBA if you follow this order. Since we are explaining these topics with clear examples. And each topic may have link or refer the examples of the previous topics. Hence it is better to follow the same order.

Topics

» Introduction to VBA
» Getting Started with VBA
» VBA Environment
» Recording a Macro
» Writing Your First VBA Macro- Hello World!
» Debugging VBA Code
» Accepting Values (Input Box) & Popup Messages (Message Box)
» Modifying and Commenting Macros or VBA Code
» Executing a Macro
» Macro Security
» Learn Macros with Examples – 15 Basic Macros for Absolute Beginners

Downloads and Useful links

Downloads
» Macro to color the selected Cell

» 15 Excel VBA Macros for Absolute Beginners:
Examples Files is available to download. You can download and explore the examples to start with Excel Macros. We have provided very basic and simple example to deal with basic things of your Excel Tasks.

Useful Links
» Shortcut Keys & Tips
» Excel Limitations and Specifications
» Excel Downloads

LIMITED TIME OFFER
By |January 1st, 2013|Excel VBA|8 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

8 Comments

  1. Rakesh August 6, 2014 at 11:38 AM - Reply

    I’d like to have a macro, called Macro1, for example, run every day at 9 AM. It works great on its own from the VB code editor in Access 2010 but I would like it to be able to execute automatically without access being open

    • PNRao August 17, 2014 at 11:19 AM - Reply

      Hi Rakesh,
      We can not schedule the macros in Excel, instead you can use Windows task scheduler and run the Excel macros using VBScript.

      Thanks-PNRao!

  2. Balaji February 24, 2015 at 3:28 PM - Reply

    hello sir, I required Exam seating arrangement vb coding in excel using Room no, Roll no, Date as inputs

  3. Vasu March 20, 2015 at 12:51 AM - Reply

    Hello Sir,

    Please help on this.

    I have set a protection setting in my Thisworkbook, this settings are for different tabs in same workbook with Workbook_Open event.

    Now I want to move all the setting code to other module but I see the event is not working now. This is because of the code moved to module. please suggest me a solution to move this code to different module and setting should applied while book opened.

    Regards,
    Murugan

    • PNRao March 21, 2015 at 3:05 PM - Reply

      Hi Vasu,

      You can use the below auto run macro in any module to trigger the procedure while opening the workbook.

      Sub Auto_Open()
      'Your code here
      MsgBox "Auto Open Event"
      End Sub
      

      Thanks-PNRao!

  4. irfan June 7, 2016 at 4:44 PM - Reply

    Hi,
    i need help to run macro,i have two excels in folder, first workbook having different sheets these sheets having cellid with this cell id i need to vlookup with another workbook which having area and zone,my question is to open a new excel with first wokbook data with sheets and vlookup with area and zone data with another workbook and first workbook data is different each daybut cells are available in another workbook,please check.

  5. srinivas January 7, 2017 at 5:50 PM - Reply

    Hello sir
    Please help on this

    i prepare attendance sheet in excel format cell one to cell six type “p” because there is no absent hence this employee get weekly incentive this identification is
    first cells to six cells continues “p” then seventh cell is automatic display “wp”
    please help this vba code

    • Abrar May 18, 2017 at 11:39 AM - Reply

      U don’t need to use VBA, just formulate the 7th Column

Leave A Comment


Related pages


excel formula correctorvb carriage returntick on excel spreadsheetexcel vba import text fileexcel iferror formulahow to lock an excel sheet with passwordexcel vba chart seriescollectionhow to build excel macrosvba check file existsestimate template excelvb6 write text filehow to remove columns in excelhow to create a countif formula in excelfinancial analyst interview questions and answers pdfmaking charts in excel 2007unprotect sheet excel 2010how to create a pie chart in excel 2013concatenate in excel 2007listbox multiple selectionexcel append tablesmacros and vba in exceldelete blank rows from excelvba excel lookupmultiple if statements vbastacked bar graph excel 2010data analyst interview questions and answers for freshersexcel vba range selectionsql pivot tutorialinsert a button in excelexcel 2007 graph tutorialhow to use the sumif function in excelvbscript tutorial for beginners step by steplock excel with passwordcount if function excellooking for duplicates in excelvlookup with trueexcel vlookup function examplessql interview questions for beginnerssample excel macro codeexcel 2013 unprotect workbookexcel check for duplicateexcel function sumifhow to collect data from multiple excel filesvba object oriented programmingexcel adding columnsexcel merge sheets into onehow to insert row in excel shortcutexcel vba graphif iserror vbadeveloper ribbon excelexcel vba combo boxaccess vba tutorialsexcel formula in vbaexcel hide duplicatesdefinition of worksheet in excelactivecell interior colorindexopen access database from excel vbahow to protect worksheet in excel 2007microsoft excel advanced tutorialmultiple checkboxes in excelhow do i autofit in excelpivot table in vbaexcel last cell in columnexcel template gantt charthow to create a clustered column chart in excelvb example programsproject timelines templateshow to create macro button in excel 2010password protect excel 2010 workbookexcel tutorial beginnersort alphabetically excelcountif functionexcel vba subtract datesworksheet cellshow to remove empty rows in excelvisual basic sample codes for beginnersdeveloping macros in excelhow to unprotect a workbook in excel 2010ddl commands in sql with syntaxautomation testing interview questions and answers pdfvba examples in excel