Using the Excel.Application InputBox Method to get range address

In this lesson we cover:

• What is the Excel.Application InputBox method?
• The different data types you can collect using the InputBox method
• How to get a range reference from a user and set a new cell color depending on what range is selected by the user
• How to use On Error Resume Next to handle when the user clicks on Cancel or closes the InputBox

Note: The InputBox Method does automatic data validation. You can see this in the last minute of the video lesson.

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]