Using the VBA InputBox Function

In this lesson we cover:

• The difference between the VBA InputBox Function and Excel Application.InputBox Method
• How to use an Input Box to get First name and Last name from a user
• The problem… what happens when a user enters a blank name?

Note: The VBA InputBox Function can only return text… to get numbers or formulas or ranges from a user, you need to use the Excel.Application InputBox method

Write your comments and feedback below

• If you have questions or comments about this lesson, write it in the section below.
• Alternatively you can email the instructor Victor at [email protected]