Insert function to 'Cancel' Button in InputBox

Hi,

I have the code below,
That code call some InputBoxes in sequence, that be filled with ocrrectly information like name, cell phone, date of purchase, etc. (sheet is in portuguese)

But I want to give a function for 'Cancel' Button, because actually if we click on cancel Button, the macro skip to the next inputbox,

I want to click in Cancel Button, and Exit Sub, I used this Tip for example

Please Login or Register  to view this content.

But if we do not fill the Text field, the Macro Exit Sub Too

Some fields are optional, so for this i search for a solution

Click in Cancel Button and Exit Sub

Somebody can help me?

Please Login or Register  to view this content.

Try this.

Please Login or Register  to view this content.

By the way, why not use a userform instead of multiple inputboxes?

Hello leleco,

The InputBox returns an empty string when the user clicks Cancel. Your macro would need to check each output string before assigning it to the cell.

Will the action for Cancel always be the same?

Oops, I was thinking of Application.InputBox.

Hi Metzger,

You Help me a Lot,

The problem was solved

Thank You