Looping sub not detecting user cancel from inputbox

[jshaw82]

Hi All, Can someone help with my sub. I'm trying to get it to do the fllowing. IF the user presses cancel the sub exits, if they enter nothing it loops until they do and if they do enter something then it runs another sub to check what they have entered is valid. I've tried userName = False but it gives type mismatch. I've tried userName = "" but then it just keeps looping as I need <>"" to do something else. Can anyone help. Regards, John

Please Login or Register  to view this content.

[jshaw82]

Ok so I sorted it by doing:

Please Login or Register  to view this content.

Then it will detect a "False"