I have a form that needs to be updated by multiple users. The information must be entered in the following format:
<a href="http://website.com">Write any title here</a> and then they can add a description
The users are not familiar with HTML and often submit it with incorrect syntax. I would like to prevent these errors prior to submission by writing some sort of validation. Is there a way to accomplish this? I imagine a macro is best for this situation. Multiple entries are often entered in a single cell (not sure if this would mess with the validation?)
Any ideas? Much appreciated!