Possible to keep userform from deleting a cells hyperlink?

[barman]

Hi,

Cell G2 on 7 different sheets has the text "Go to Location" entered that is hyperlinked to an 8th sheet.

I created a userform so different people can change the text of that link if they want to. It works great as long as each text box is filled in when submitted, the new text is inserted into G2 on each sheet and that text remains hyperlinked... the issue is if the user submits the userform and leaves a textbox blank then it deletes the hyperlink in cell G2 on that sheet. So when they reopen the userform to add the text again, the name is added but no longer hyperlinked.

Is there a way to make sure that if the userform is submitted with a blank textbox, the cell remains hyperlinked?

Please Login or Register  to view this content.

Thank you!

[Trebor76]

Hi barman,

Something like this:

Please Login or Register  to view this content.

Regards,

Robert