What is a loop? A loop is to repeatedly do something until a specific event occurs. In VBA it is to repeat a line, or lines, of code until a certain criteria is meet. There are a couple of different loops in VBA and we will cover all of them with a couple of demos, first lets go over some basics.
Archive | Microsoft Office RSS feed for this section 
How to fix Word 2007 Crashes on Exit
Sometimes while using Word 2007 you can come across many different errors with it. One of the most common I have seen is when Word 2007 crashes whenever you try to close it. Here is how you fix it. How to fix it Run Regedit from the run box or the start menu. The registry [...]
View Text Boundaries in Word 2010 or Word 2007
When formatting in Word, might need to see the text boundaries.Here is how to view text boundaries in Word 2007 and Word 2007.
Fix OST Files in Outlook with SCANPST.EXE
Depending on how you have your Outlook setup you might have an OST. OST files or offline folder files, are typically used when you chose to have Outlook store copies of your email messages, calendar and other items locally for you. From time to time these OST files tend to get corrupt. Here is a [...]
Excel How To: Calculate Remaining Days in the Year
For this Excel how to tip, we are looking at how to calculate the remaining day in the year. This is a really easy, and quick to do.
How to Disable Reply all and Forward in Outlook 2010 with a Macro
Sometimes I want to send an email to a bunch of people, but I don’t want everyone hitting reply all. Choosing the BCC route is a good choice to stop this, but then everyone won’t know who got the email and decided to forward it to everyone else. Thus causing more email clutter in their [...]
How to Show the Developer Tab in Office 2010
If you are like me and develop different code for Office documents you probably need the Developer Tab in the Ribbon. In Office 2010, sense this is the beta they might change it later, here are the current steps to take to enable it. Before Showing Developer Tab By default the developer tab is not [...]
How to Create and Publish Blog Posts in Word 2010
One of the cool features to Word 2010 and Word 2007 is the ability to create and publish blog posts. Here is a quick tutorial on how to set it up. Getting Started Open up Word 2010, or Word 2007, and click on the File tab to go to the Backstage View. Click on New [...]
How to Add Trusted Locations in Office 2010
In this article I will show you how easy it is to have a trusted location in Office 2010 and how to remove them when they are not needed.
How To Take Screenshots with Word 2010
Some of the cool new features in Word 2010 is the ability to take a screenshot within the program itself. Check out how to do it below:
Add Holidays to Outlook 2010 the Easy Way
If you are like me and forget all the holidays here is a easy and simple way to add holidays to Outlook 2010. Now you wont miss a holiday.
Frmcache.dat Errors and how to Fix Them for Outlook 2007
Frmcache.dat errors can pop up when you are trying to use Outlook, stopping you from using it. Here is a quick way to fix these problems.
Disable Protected View in Office 2010
Protected View for Office 2010 can be a good or an annoying reoccurrence. Here is how to enable or disable protected view for Office 2010.
Change Color Scheme in Office 2010
Tried of the default colors of the Office 2010 products? Want to change them up a bit? Here is how to change color scheme in Office 2010.
Excel Attachments Open Blank from Outlook Fix
One of the most common problems with Outlook is opening attachments. Here is how to fix when your excel attachments open blank from outlook.
Get Free Email Updates
Subscribe to our e-mail newsletter to receive updates.
