Loads of FREE content on Microsoft Office Training

Monthly Archives: June 2016

Archive of posts published in the specified Month

Jun
12

Creating a Table of Contents in Microsoft Excel

Each Microsoft Excel file can contain up to 255 Worksheets. With that much data in a single Excel file it can be a bit daunting navigating to the data that you are looking for. With just a little bit of Excel VBA you…

Jun
3

Highlight Active Row in Excel with VBA

I was recently invited to participate in an educational conference for a group of Utah State employees. I gave a 2 hour demo session on working with various features of¬†Microsoft Excel to this group of 200+ attendees. I had a lot of fun…

Jun
2

Populate a Microsoft Excel VBA UserForm ComboBox with Worksheet Names

One aspect of teaching online courses, that I enjoy, is getting questions from curious students on the course material and beyond. In my course, Master Microsoft Excel Macros and VBA, ¬†in Section, I demonstrate how to populate a Combo Box, on an Excel…

Jun
2

Microsoft Excel VBA Procedure Types

I recently had an excellent question asked in one of my Microsoft Excel Macros and VBA courses I published on Udemy and I would like to share the question and response with you. Question: In Microsoft Excel VBA what is the differences between…

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.