Tag Archives: tutorial

VBAString Tip 3: How To Make An Input Box In Excel VBA

This post will use VBA to show you how to display whatever a user enters in an input box.

For example, if a user enters “123456789”, the output should be “account# 123456789 is available”.

First, add a button to your worksheet and input this VBA code behind it:

Watch this:

Let me know if you have any questions

I consent to having this website store my submitted information so they can respond to my inquiry. See our privacy policy to learn more how we use data.