I'm trying to verify input given via an input box:
This works, however... Because I can't quite translate what's in my mind into VBA, I'm stuck with the following cases which should all trigger a failure MsgBox and repeat the loop:
- If the user enters a white space
- If the user enters a name with a white space
- If the user enters a name that doesn't match any of the sheets in the workbook.
The latter, if I'm not mistaken, I need to do with Intersect, something like (and please correct me if I'm wrong here):
I just don't know how to translate that into VBA.
And on a slightly different note, can an evaluation contain ORs? For example, If (myNameInput = "" || myNameInput = False || ...etc.) Then
Bookmarks