Blog Archives

Tom’s Tutorials For Excel: Making Your Hyperlinks User-Friendly

Tom’s Tutorials For Excel: Making Your Hyperlinks User-Friendly
When you put hyperlinks in cells on a worksheet, it’s a good practice to present them in a user-friendly, intuitive way. For example, the pictures show an original list of hyperlinked cells with their Microsoft-induced wordy screen tips. The modified list was created by the below macro to show those same cells more intuitively,

Read more ›

Posted in Tom's Tutorials for Excel
Tags:

Tom’s Tutorials For Excel: Sorting Email Addresses by Domain and Recipient

Tom’s Tutorials For Excel: Sorting Email Addresses by Domain and Recipient

Yesterday, I posted this method for parsing the recipient and domain names from an email address.

As an example of why you would want to separate a recipient name from its domain name,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Parsing an Email Address for Recipient and Domain Names

Tom’s Tutorials For Excel: Parsing an Email Address for Recipient and Domain Names

If you have a list of email addresses and you want to parse the recipient and domain names, you can do so with the following formulas as shown in the picture. Note that the formulas will take into account the varying lengths of recipient and domain names.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Verifying Your Internet Connection

Tom’s Tutorials For Excel: Verifying Your Internet Connection

With the help of an API declaration, here’s a method for verifying if the active workbook’s system is connected to the internet.

Thanks to MS Excel MVP Mike Alexander at Datapig Technologies for his help with this to include wireless connections in the verification process.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Reading the Registry for Your Email (non-Web Mail) Client

Tom’s Tutorials For Excel: Reading the Registry for Your Email (non-Web Mail) Client

Here’s a macro that reads your Registry and tells you the name of your email client. This does not include web mail such as accounts in Gmail and Yahoo.

My email client is Microsoft Outlook.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Hyperlinking a CommandButton to the Internet

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 CommandButton’s caption is the literal URL address.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Updating Links (or Not)

Tom’s Tutorials For Excel: Updating Links (or Not)

You’ve no doubt seen this pop-up message upon opening a workbook:

To automatically update links sans VBA, if the work being done is always on your computer…
…In versions 2003 or before: Tools >

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Finding and Deleting Phantom Links

Tom’s Tutorials For Excel: Finding and Deleting Phantom Links

If you’ve ever wondered why this message pops up after you are sure you’ve deleted all your workbook’s links, well, join the club. It’s a common problem because some links can be difficult to find.

In my 20 years working with Excel,

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,

Tom’s Tutorials For Excel: Taking Stock

Tom’s Tutorials For Excel: Taking Stock

Here’s a fast and easy way to download the daily pricing activity of a company’s stock, from the first day it went public up to its last closing date. The following macro uses Microsoft as an example.

Microsoft’s stock abbreviation is MSFT as defined by the strSymbol variable.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , ,

Tom’s Tutorials for Excel: Delete Hyperlinks, Keep Their Text

Tom’s Tutorials for Excel: Delete Hyperlinks, Keep Their Text

At some point you have probably inherited or created a worksheet that contains active hyperlinks, when all you want in the cells is the hyperlink text itself. It’s annoying to unwittingly click onto a hyperlink cell that interrupts your work by suddenly taking you away from your worksheet.

Read more ›

Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , , ,