×

VBA User-Defined Functions

VBA Function To Validate Range Address

VBA Function To Validate Range Address

You Need To Check Your Cell Address Input A common task when using VBA with Excel is to validate cell...

Get URL Webpage Title With VBA Function

Get URL Webpage Title With VBA Function

What This VBA Code Does Manually copying and pasting website titles can be tedious, error-prone, and time-consuming. However, by writing...

VBA Function To Test For Internet Connection

VBA Function To Test For Internet Connection

What This VBA Code Does Sometimes you might be writing macro code that requires reaching out to cloud-based files or...

How To Use VBA Code With Oracle's Smart View Add-in

How To Use VBA Code With Oracle's Smart View Add-in

What Is The Oracle Smart View Add-in? The Smart View Excel Add-in is a free Oracle tool that allows you...

VBA To Determine If Number Is Odd Or Even

VBA To Determine If Number Is Odd Or Even

What This VBA Code Does You may have found yourself in a situation where you need to determine if a...

VBA Function To Determine If A Worksheet Exists In A Workbook

VBA Function To Determine If A Worksheet Exists In A Workbook

What This VBA Code Does The following VBA macro code provides a function that tests if a worksheet exists in...

How To Change The Mouse Cursor Icon In Your VBA Userform

How To Change The Mouse Cursor Icon In Your VBA Userform

Why Change Your Userform's Cursor? There may be certain instances where it makes sense to change the look of the...

VBA Function To Determine What Is Currently Selected On Spreadsheet

VBA Function To Determine What Is Currently Selected On Spreadsheet

What This VBA Macro Does This VBA function is a handy piece of code that categorizes what is currently selected...

VBA Function To Determine If An Excel File Name Is Valid

VBA Function To Determine If An Excel File Name Is Valid

What This VBA Macro Code Does I've written a few macros over the past few days that have required the...

How To Create Your Own User-Defined Functions With VBA

How To Create Your Own User-Defined Functions With VBA

Hey everyone! Chris here and I want to introduce you to author/blogger Allen Wyatt. Allen has been running a weekly...

Using Cell Formatting Logic With Excel Formulas

Using Cell Formatting Logic With Excel Formulas

Wishful Thinking?  Have you ever had a time where you wished you could write an IF formula in Excel based on...