Input Box Cancel Button

Below is one of the variations of code I have tried to use in order to get my the cancel button on the inputbox to not run the rest of the code in the sub.

Im not out of ideas and could use some help. Please and thank you.

Please Login or Register  to view this content.

It worked to an extent, so I was trying to play with it myself because it was definitely closer than what I got.

Hi
Try this:

Please Login or Register  to view this content.

Originally I hadn't allowed for the Message box option. Here I just put the response value in to A1 as a test but adapt as required.

DBY

That works perfectly, thank you, I have been missing with that code for like 2 hours.

Glad to have helped. It wasn't as easy as I first thought, hence I removed my first post. The 'Type:=2' options seems to make the difference. Thanks for the Rep mark.

Glad to give it to you.

If you don't mind answering me this, what does the Type:=2 mean. I understand most of the code but this throws me off.

I found my information here:

http://theitservice.co.uk/blog/input...od-and-strptr/

There is a way with the strptr() function but as it's not supported by Microsoft anymore I thought it was best avoided. There's a list of Type parameters half way down the page. The one I chose Type 2 returns a text string.

Hope this helps.