• Customize Startup - Use a simple macro to further customize startup wh...
• Faster Macros - Have Excel calculate Excel macros faster by instal...
• Scroll Area - Back in August, the podcast showed a trick for pre...
• Formatting Macro - Someone posed this question in a recent Power Exce...
• Gathering Entries - In offices throughout the US, people are starting ...
• Sum Bold - Mudit asks, is there any way to sum just the bold ...
• Spelling Numbers - George sends in a question ? how can you convert a...
• Event Handlers - In honor of Memorial Day in the United States, a q...
• Custom Functions - Way back in Episode 499, I talked about adding the...
• Concatenate Range in VBA - Back in Episode 578, I used an incredibly complex ...
• Unprotect Green Cells - Today, the questioner asks how to unprotect the gr...
• Run Macro Button - You?ve created a simple macro and want to assign t...
• Redocking Properties - If, in the VBA editor, you accidentally undock the...
• Unhide All Sheets - You can hide several sheets with a single command,...
• Spilling Values II - In today?s episode, I take a look at three non-mac...
• VBA Naming Ranges - The macro recorder uses a confusing way to name ra...
• Relative Recording - When recording a macro to enter a SUM formula, you...
• Combining Worksheets - James asks how he can combine data from all rows o...
• Extracting Links - Have a bunch of hyperlinks in Excel? Extract the URL from each link to a new column.
• Scraping Webpages - VBA to grab data from all web pages in a list
• Proper Case - Changing names to proper case
• Recording Naming - Use a macro to name the current range
• Timestamp - A VBA event handler to timestamp new records in an Excel worksheet
• Tracking Runners - Track finishing times for runners in Excel.
• VBA in 2007 - VBA is alive and well in Excel 2007
• Scale Selection - A macro to scale a selected range.
• VBA Userforms - Create a userform in VBA
• Choose Value - VBA userform to allow you to choose a value.
• Insert Worksheets - Add a new worksheet for every customer on the summary worksheet

• Excel training videos about Charts
• Excel training videos about VBA
• Excel training videos about Pivot Tables
• Excel training videos about Data Analysis
• Excel training videos about Formulas
• Excel training videos about Formatting
• Excel training videos about Printing
• Excel training videos about Excel 2007
• Index to all videos

MrExcel.com provides examples of Visual Basic procedures for illustration only, without warranty either expressed or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose. The Visual Basic procedures on this web site are provided "as is" and we do not guarantee that they can be used in all situations.