Tom’s Tutorials For Excel: Reading the Registry for Your Email Client Here’s a macro that reads your Registry and tells you the name of your email client. My email client is Microsoft Outlook. When I run this macro, this is … Continue reading →

Tom’s Tutorials For Excel: Adding a Cost Increase On Entry With a WorksheetChange event you can enter a number in a cell, and do an immediate calculation upon entry of that number to display a more meaningful number. Suppose you … Continue reading →

Tom’s Tutorials For Excel: Case Sensitive LOOKUP Here’s how you can attack a lookup action for a unique list of items, when the only difference among the characters in the list is their upper or lower case. The criteria item … Continue reading →

Tom’s Tutorials For Excel: Sorting Birthdays, Excluding the Year Companies and organizations often keep a list of their members’ birth dates, for purposes of sending out birthday greetings or managing employees’ birthdays with a complimentary day off work. As the … Continue reading →

Tom’s Tutorials For Excel: Hyperlinking a CommandButton to the Internet When you have an ActiveX CommandButton on a UserForm or embedded onto your worksheet, the FollowHyperlink method can take you to your favorite website. In the above picture, the green … Continue reading →

Tom’s Tutorials For Excel: Populating and Sorting Unique Items in a ListBox or ComboBox There are times when you need to populate a ListBox or ComboBox with unique items from a dynamic range containing many repeated items. You’ll also want … Continue reading →

Tom’s Tutorials For Excel: Filtering Dates When it comes to filtering dates, a little VBA goes a long way in dealing with the nemesis of seemingly countless different formats a date can be represented in Excel. In the picture, an … Continue reading →