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.


Please remember to subscribe to my youtube channel

Been helped? Get these!