Subscribe
Tutorial search

Excel Macros Tutorials

We hope that you will enjoy our Excel Macros tutorials. Feel free to contact us if you would like to be a tutorial hero and contribute your own Excel Macros tutorial to our site. Thank you !

Sort by:
VBA: Yes or No Message Box
VBA: Yes or No Message Box
Here is code to present the user with a Yes/No Message box.
Difficulty:
How To Get the Weekday as Text in Excel VBA
How To Get the Weekday as Text in Excel VBA
This tutorial explains how to get the weekday as text in Excel, using VBA, and giving a function to do the job. We also give a method which avoids using macros, for comparison.
Difficulty:
VBA: Find Text in a String (instr)
VBA: Find Text in a String (instr)
You can use the instr function in VBA to test if a string contains certain text. The result is the number of times the specified text appears in the string.
Difficulty:
Unhiding multiple sheets at the same time
Unhiding multiple sheets at the same time
Shows how to hide and unhide multiple sheets at the same time using the AssumeIT macros
Difficulty:
Removing #DIV/0! errors from your spreadsheets
Removing #DIV/0! errors from your spreadsheets
Shows how to remove #DIV/0! errors from your spreadsheets permanently using the AssumeIT macros
Difficulty:
Protecting and unprotecting all the sheets in your spreadsheet
Protecting and unprotecting all the sheets in your spreadsheet
How to protect and unprotect all the sheets in yout spreadsheets in one go using the same password with the AssumeIT macros
Difficulty:
Running sensitivities that involve macros
Running sensitivities that involve macros
Shows how to run the required macros when run the sensitivities with the AssumeIT macros
Difficulty:
Overwriting formula to run sensitivites
Overwriting formula to run sensitivites
Shows how to overwrite formula cells when you want to run sensitivities as if they were inputs using AssumeIT macros
Difficulty:
Screating scenarios with the AssumeIT macros
Screating scenarios with the AssumeIT macros
How to include scenarios into your own spreadsheet by using the AssumeIT macros
Difficulty:
Finding the most sensitive input in your spreadsheet with AssumeIT macros
Finding the most sensitive input in your spreadsheet with AssumeIT macros
How to find which of your spreadsheet inputs are the most sensitive using the AssumeIT macros
Difficulty:
Saving sensitivities with AssumeIT macros
Saving sensitivities with AssumeIT macros
How to save, open and change your spreadsheet sensitiviteis using your AssumeIT macro.
Difficulty:
Running sensitivites over multiple sheets
Running sensitivites over multiple sheets
Shows how to run the sensitivity tools within the AssumeIT macro over multiple sheets
Difficulty:
Using AssumeIT in Excel- simple example
Using AssumeIT in Excel- simple example
Shows how to run a simple sensitivity using the AssumeIT macros in Excel.
Difficulty:
Insert Data from Excel to SQL Server
Insert Data from Excel to SQL Server
Shows how to read data from an Excel spreadsheet and insert it into a SQL Server database using VBA and ADODB.
Difficulty:
How to record and use a Macro in Excel
How to record and use a Macro in Excel
This is a video tutorial which teaches you how to use and record macros with the macro recorder in excel. The main website is : http://www.ExcelisHell.com
Difficulty:
Total Tutorials in Category: 27