inputbox cancel

**jacobsoo** · 11-25-2013, 03:41 PM

Hi people of excelforum.

I stuck here in my inputbox, and can't seem to find an solution for the cancel button. I already tried dozens of options and it's not getting me any where.
The problem i have might be simple to some of you.

As soon as i use my macro I can't use the cancel button, I have to continue the whole thing to finish it. If i use the cancel button it simply give me an error in return, and after that the macro is being aborted.

The code I am using is for my monthly payments, and by activating an macro it copy's al relevant data to a new sheet with the inputbox to fill in the new sheet name.

The Code I use,

Please Login or Register  to view this content.

Regards Olaf.

**ajryan88** · 11-25-2013, 08:51 PM

Hi,

Please use code tags when posting code. This is rule 3 of the Forum Rules.

As for your problem:
Pressing the Cancel button on the InputBox will return a value of "" (empty string) to the variable "newname", which you are then using to assign to a worksheet name (which you obviously can't give a worksheet no name).

So all you need to do is check if newname has a value of "" before assigning it to the worksheet name, and exit the subroutine if it is.

Hope this helps

**alansidman** · 11-25-2013, 08:55 PM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(I have added them for you today. Please read all forum rules and comply in the future.

**jacobsoo** · 11-26-2013, 07:03 AM

First of al, thanks for the update to the forum rule's. I just forgot them, i signed up long time ago and yesterday i started to use the forum, my mistake.

For the code, thanks to. I tried the part already couple of time's but it came up with an compile error or with an copy'd sheet. I placed the "simple line" in diverent spot and it works just great. Thanks for that.

The code is now like.

Please Login or Register  to view this content.

Again many thanks, Olaf.

inputbox cancel

LinkBack

Thread Tools

Rate This Thread

Display

inputbox cancel

Re: inputbox cancel

Re: inputbox cancel

Re: inputbox cancel

Thread Information

Users Browsing this Thread

Similar Threads

InputBox and Cancel

[SOLVED] Cancel my Inputbox

Cancel on Inputbox not work

InputBox: Cancel/X properties

InputBox - Cancel

Bookmarks

Bookmarks

Posting Permissions