Cancel on Inputbox not work

Giday to all

I created an inputbox to create an new sheet with name but when click on cancel it still create new sheet.
So how can I stop that?

Please Login or Register  to view this content.

test.xlsm

Try and add this....

Please Login or Register  to view this content.

or if you want to goto your msgbox

Please Login or Register  to view this content.

Oh you so quick and it look so simple hehe,

Thank you jeffreybrown for quickest response I've seen, cheers mate

You're welcome...glad it worked for you