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:
But the ElseIf statement fails due to type mismatch. Here is my code for adding to the table as it stands:
All help is greatly appreciated.
Bookmarks