Handle cancellation of InputBox to select range

by

This is a problem when selection a range with an inputbox. Excel returns an error before the range is returned, and it carries this error on when you press cancel.

You should therefore actively handle this error. If you don’t want anything to happen when you press cancel, you can just use the code like this:

Sub SetRange()
    Dim selectRange As Range

    On Error Resume Next
        Set selectRange = Application.InputBox("Select your range", "Hello", , , , , , 8)
    Err.Clear
    On Error GoTo 0
End Sub

More Related Contents:

  1. VBA Excel simple Error Handling
  2. Save excel file multiple times with file names in another workbook.
  3. Function to convert column number to letter?
  4. Read/Parse text file line by line in VBA
  5. How do I find the last column with data?
  6. Better way to find last used row
  7. Excel VBA: Answer gets “stuck”
  8. 2 Dimensional array from range [closed]
  9. Save multiple sheets to .pdf
  10. Having multiple Excel instances launched, how can I get the Application Object for all of them?
  11. filter out multiple criteria using excel vba
  12. Excel VBA autofilter all but three
  13. Cells.Find() Raises “Runtime Error 91: Object Variable or With Block Not Set”
  14. Dir() function not working in Mac Excel 2011 VBA
  15. Excel VBA code to copy a specific string to clipboard
  16. Merge values of column B based on common values on column A
  17. How to use workbook.saveas with automatic Overwrite
  18. How to import a table from web page (with “div class”) to excel?
  19. Excel VBA – Range.Copy transpose paste
  20. How to use FindWindow to find a visible or invisible window with a partial name in VBA
  21. How do you get a Range to return its Name?
  22. Passing variable from Form to Module in VBA
  23. Excel VBA: Convert a date string to a Unix timestamp
  24. In Excel, can I use a hyperlink to run vba macro?
  25. Excel VBA – exit for loop
  26. Are ActiveX Controls Disabled?
  27. VBA WinHTTP to download file from password proteced https website
  28. VBA: Modify chart data range
  29. How to do a “Save As” in vba code, saving my current Excel workbook with datestamp?
  30. How to save semi-colon delimited csv file using VBA?

Leave a Comment