| HOME > RSS Feeds > - Latest Tutorial Listings For Macros | ||
| Add To: | 
|
 |
Here is code to present the user with a Yes/No Message box.
Demo Microsoft® Unified Communications One Inbox, One Interface. Tear Down Walls That Separate Phones From PCs. See How
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.
Microsoft BPOS Demo Microsoft Business Productivity Online Suite demo. Watch it now.
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.
Autodesk - Civil 3D - Transportation Accelerate Projects with Integrated Data Sources & Automatic Documentation.
Removing #DIV/0! errors from your spreadsheets
Shows how to remove #DIV/0! errors from your spreadsheets permanently using the AssumeIT macros
Official Site: Microsoft Discover Business Productivity Online Suite. Watch the demo now.
Unhiding multiple sheets at the same time
Shows how to hide and unhide multiple sheets at the same time using the AssumeIT macros
Query Your Database the Easy Way Retrieve and Update data without writing a line of SQL. Try QweryBuilder Today!
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
Running sensitivities that involve macros
Shows how to run the required macros when run the sensitivities with the AssumeIT macros
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
Screating scenarios with the AssumeIT macros
How to include scenarios into your own spreadsheet by using the AssumeIT macros
Saving sensitivities with AssumeIT macros
How to save, open and change your spreadsheet sensitiviteis using your AssumeIT macro.