| HOME > RSS Feeds > - Latest Tutorial Listings For Macros | ||
| Add To: | 
|
 |
Here is code to present the user with a Yes/No Message box.
Microsoft BPOS Demo Microsoft Business Productivity Online Suite demo. Watch it now.
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.
Official Site: Microsoft Discover Business Productivity Online Suite. Watch the demo 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 Inventor® Go Beyond 3D To Digital Prototyping With Autodesk Inventor. Learn How.
Removing #DIV/0! errors from your spreadsheets
Shows how to remove #DIV/0! errors from your spreadsheets permanently using the AssumeIT macros
Automate Software Builds with Visual Build Pro Easily create an automated, repeatable process for building and deploying software.
Unhiding multiple sheets at the same time
Shows how to hide and unhide multiple sheets at the same time using the AssumeIT macros
Microsoft Exchange Server 2010 Simplify Administration and Deployment of Messaging - Free Download.
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.