Curriculum
| Title | Description | |
| Macros -Introduction | In this post, you will learn about Macros in Excel and their uses. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/macros-in-microsoft-excel/’,’_blank’)”] |
| Record Macros | In this post, you will learn to record macros in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-record-macros-in-absolute-and-relative-mode-in-excel/’,’_blank’)”] |
| Add a Macro to Toolbar | In this post, you will learn to Add a Macro to Toolbar in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-add-a-macro-to-the-toolbar-in-excel/’,’_blank’)”] |
| Cut Copy and Paste in Macros | In this post, you will learn about cut, copy and paste using macros in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/cut-copy-and-paste-using-a-macro-in-excel/’,’_blank’)”] |
| Macro Security Settings | In this post, you will learn about Macro Security Settings in Excel | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/macro-security-settings-in-excel/’,’_blank’)”] |
| Password Protect an macro Excel | In this post, you will learn to password protect an macro in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-password-protect-an-excel-macro/’,’_blank’)”] |
| Swapping Two Values | In this post, you will learn to swap two values using macros in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/swapping-two-values-using-macros-in-excel/’,’_blank’)”] |
| Macro Recorder | In this post, you will learn about macro recorder in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/macro-recorder-in-microsoft-excel/’,’_blank’)”] |
| Getting Started in Excel VBA | In this post, you will learn about Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/getting-started-with-vba-in-excel/’,’_blank’)”] |
| MsgBox in Excel VBA | In this post, you will learn about MsgBox in Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/msgbox-in-excel-vba/’,’_blank’)”] |
| Reverse a Text | In this post, you will learn to reverse a text using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-reverse-a-string-in-microsoft-excel/’,’_blank’)”] |
| Remove Multiple Line Breaks | In this post, you will learn to remove multiple line breaks using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-quickly-remove-multiple-line-breaks-in-excel-using-vba-code/’,’_blank’)”] |
| Active Cell Column and Row | In this post, you will learn to find the Active Cell Column and Row in | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-get-active-cell-column-and-row-in-excel-vba/’,’_blank’)”] |
| Excel VBA. | #VALUE! | |
| Get and Set Cell Value | In this post, you will learn to create get and set cell value using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/get-and-set-cell-value-in-excel-vba/’,’_blank’)”] |
| Clear Cells | In this post, you will learn to clear cells using Excel VBA | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-clear-cells-in-excel-vba/’,’_blank’)”] |
| Sheets and Worksheets | In this post, you will learn about inserting sheets and worksheets using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/sheets-worksheets-in-excel-vba/’,’_blank’)”] |
| List Worksheets in a Workbook | In this post, you will learn to list worksheets in a workbook using Excel VBA . | |
| Count Number of Sheets | In this post, you will learn to count the number of sheets using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-count-number-of-sheets-in-excel-vba/’,’_blank’)”] |
| Protect & Unprotect Worksheets | In this post, you will learn to protect and unprotect worksheet using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/protect-unprotect-worksheets-in-excel-vba/’,’_blank’)”] |
| Open & Close WorkBook | In this post, you will learn to Open & Close WorkBook using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/close-open-workbook-in-excel-vba/’,’_blank’)”] |
| Loop Through All Worksheets | In this post, you will learn to Loop Through All Worksheets in Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/loop-through-all-sheets-in-workbook-in-excel-vba/’,’_blank’)”] |
| Delete & Clear Worksheet | In this post, you will learn to Delete & Clear Worksheet using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/delete-and-clear-worksheet-in-excel-vba/’,’_blank’)”] |
| Sheet Name | In this post, you will learn to get sheet name using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-get-sheet-name-in-excel-vba/’,’_blank’)”] |
| Active Sheet & Select Sheet | In this post, you will learn how you can select a worksheet and activate it using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/active-sheet-select-sheet-in-excel-vba/’,’_blank’)”] |
| Create New Workbook | In this post, you will learn to Create New Workbook using Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/creating-new-workbooks-in-excel-vba/’,’_blank’)”] |
| Get File Path and Name | In this post, you will learn to Get File Path and Name in Excel. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/how-to-get-the-file-path-and-file-name-using-excel-vba/’,’_blank’)”] |
| Formulas in Excel VBA | In this post, you will learn about the formulas in excel VBA | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/formulas-in-excel-vba-a-beginners-guide/’,’_blank’)”] |
| Saving Files | In this post, you will learn about saving files in Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/saving-files-in-excel-vba/’,’_blank’)”] |
| Conditional Statements in Excel VBA | In this post, you will learn about Conditional Statements in Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/conditional-statements-in-excel-vba/’,’_blank’)”] |
| Loops in Excel VBA | In this post, you will learn about Loops in Excel VBA. | [gamipress_button label=”Read” onclick=”window.open(‘https://developerpublish.com/loops-in-excel-vba-with-examples/’,’_blank’)”] |