Loading...

Follow The Spreadsheet Guru on Feedspot

Continue with Google
Continue with Facebook
or

Valid
What Is The Office Insider Version? The “Insider” version of Office (formerly known as “Insider Fast”) is used to test the latest ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
On August 28th, 2019, Microsoft unveiled a new Excel function with the intent of making 3 beloved and rivaled functions obsolete. The ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
We Finally Got It! On June 5th, 2019 Microsoft released a feature to Office 365 that allows Excel users to pull real-time stock prices ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Today I’m going to give you behind-the-scenes access to all the equipment I use here at the TSG headquarters (aka the office space in my ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
By default Excel will convert text to a hyperlink if it determines your data is in a URL or email address format. This is typically not a ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
The Spreadsheet Guru by Chris Newman - 4M ago
VBA is a coding language used by millions of people across the world to automate tasks in Microsoft Office products. It’s a language that ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
I’m currently working on a consulting project where a VBA macro within an Excel file needs to run every morning before folks get into the ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
The Need For A Modern UILet’s face it, VBA Userforms haven’t had much love from Microsoft over the past 10 or so years…..and it shows ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
In this article, I am going to explain the process I use to create an emphasis effect on my userforms when the user hovers their mouse over ..read more
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 
Why Is This Important?When you are writing VBA macros that rely on a user’s selection, you want to make sure they have selected the ..read more

Read for later

Articles marked as Favorite are saved for later viewing.
close
  • Show original
  • .
  • Share
  • .
  • Favorite
  • .
  • Email
  • .
  • Add Tags 

Separate tags by commas
To access this feature, please upgrade your account.
Start your free month
Free Preview