This tutorial will explain how to find a value in an Excel column using the Find function in VBA.

In this guide, I will start with VBA basics and give you practical examples of utilizing custom functions to unlock a whole new level of Excel mastery.

Fortunately, Visual Basic for Applications’ InputBox function supports this task, so you won’t have to work very hard! You’ll learn how to select a range using InputBox in this article.