I'll start by saying that this seems a poor example to learn userforms with, there is little to do with them here, maybe a single listbox at the end.
That being so, some thoughts.
Links always seem to have a ! in, so you could look at the formula for that. Then look backwards and forwards for a comma and a bracket. That should get you the link, or at least 75% of them. ANy anomalies can be enhanced afterwards.
