Runtime Error 91 when Macro canceled

I have the following macro that works fine when the requested Input is supplied.

However, if you hit "Cancel" or just don't input anything, an error message is displayed along with the Message Box stating that "No Recipe # Chosen":
"Run-time error '91': Object variable or With block variable not set"

I want the macro to stop if no Input is given or if the user hits Cancel. What can I add or change to make this happen?

Here's the code:

Please Login or Register  to view this content.

Add this line

Please Login or Register  to view this content.

Fluff13, Thanks so much! I knew it was something simple. I am a Super Newbie with VBA, obviously.

Glad to help & thanks for the feedback.

You also might want to take into consideration the modification suggested by protonleah.
Whilst your code will work it's not the "normal" way of writing it.

Originally Posted by Fluff13

Glad to help & thanks for the feedback.

You also might want to take into consideration the modification suggested by protonleah.
Whilst your code will work it's not the "normal" way of writing it.

Thanks! I went in a revised to use both methods I rearranged the syntax and left the NOT out of the other method and kept your Exit Sub. I don't know why I did that, it just made more sense to me. Either way, it works the way I wanted it to.

I appreciate the help and the extra explanation.