With input boxes, is there something that allows the user to press "Cancel" without getting an error message.
I have an InputBox Method, the other method is an InputBox Function. There seems to be solutions for the latter but I can't find anything for this.
My selection is a Range.
The code I have takes a range and copies it elsewhere, making a modification to the string at the same time.
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by AlphaFrog; 07-26-2018 at 02:28 AM.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
It's not quite working.
I don't think it likes the statement "if a range Is Nothing", just as a hunch.
I can't diagnose "not quite working". What did you do (show your whole code with the new changes), and describe what exactly happens? If it errors, give the error description, and press the debug button and say what line is highlighted.
Last edited by AlphaFrog; 07-26-2018 at 06:48 AM.
I get an error message: Run-time error '424' Object required
The code is shown below.
The debug highlight is at the line: Set Range2 = Application.InputBox("Paste To", xTitleId, Range2.Address, Type:=8)
Please Login or Register to view this content.
Each of the InputBox lines needs to be inside a On Error Resume Next pair to handle the Cancel button.
Mimic the code for getting Range1 when getting Range2.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
It's still not working.
This time there's no error message but the data gets pasted anyway, even though Cancel is pressed twice.
It should actually Exit after the first Cancel.
Please Login or Register to view this content.
Re: InputBox "Cancel" returns error
Hi !
Instead of On Error statement just use a Variant variable and check the result when cancelling …
Please Login or Register to view this content.
@AlphaFrog, your solution at post #9 works as intended.
Thanks very much.
That will work with Application.Match, which returns an error value when the search term is not there, but for the Application.InputBox issue, there will still be a run-time error when the user presses cancel.Originally Posted by Marc L
Application.InputBox returns the Boolean value False when cancel is pressed.
The keyword Set in
will cause an error when the user presses cancel, but is required if the user doesn'tPlease Login or Register to view this content.
Yes thanks, my bad as I misread / did not see that was the Excel InputBox and not the VBA one …
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks