Exit Sub on InputBox Cancel

So it seems like this should be simple beyond belief, but regrettably excel doesn't agree, and multiple online searches have failed to produce solutions that work. I have two tables that I need to add and remove names from by pushing corresponding buttons, which bring up a prompt for the name to be entered in. If the user pushes 'Cancel', I just need the macro to exit. My If statement works if the user inputs and empty string, but if they push cancel it populates a 'False' cell to the table, instead of exiting.

I have tried such code as:

Please Login or Register  to view this content.

But the ElseIf statement fails due to type mismatch. Here is my code for adding to the table as it stands:

Please Login or Register  to view this content.

All help is greatly appreciated.

Good evening qwerty7

Use this line to handle the cancelling bit :

Please Login or Register  to view this content.

HTH

DominicB

It actually turned out to be the "False" in quotes that solved it, which I find curious becuase it seems like the False that excel automatically populates should be a boolean, not a string. False without the quotes gave me an error, not sure why....

Thank you all much for the help though.