I'm looking for a list of characters that are invalid in a hyperlink address (at least as far as Excel is concerned).
I have a form where the user can input a hyperlink address, and through VBA convert it to an active hyperlink. I've discovered that if the address has invalid characters (such as a space), the code hangs up. In order to prevent that from happening, I would like to have a warning pop-up to alert the user that the address is invalid, before any damage is done. But I haven't been able to find anything to tell me when Excel considers a hyperlink address to be invalid. Can anyone help me here?
I have a form where the user can input a hyperlink address, and through VBA convert it to an active hyperlink. I've discovered that if the address has invalid characters (such as a space), the code hangs up. In order to prevent that from happening, I would like to have a warning pop-up to alert the user that the address is invalid, before any damage is done. But I haven't been able to find anything to tell me when Excel considers a hyperlink address to be invalid. Can anyone help me here?
