Follow hyperlink stored in label controltiptext when clicking on userform label

Hi all,

I've got about 100 labels on a userform, with an url stored in the controltiptext
Is there an easy way to click on the label and then follow the hyperlink stored in the controltiptext of the label I clicked on, without having to type a gazillion times:

Please Login or Register  to view this content.

I tried 'application.caller', but that didn't work.
Any other easy approach to do this?

Thanks,

Jasper

Hi there,

Take a look at the attached workbook and see if it does what you need.

I've inserted dummy hyperlink addresses (e.g. "aaa") as the ControlTipText properties of the various labels on the UserForm - you can change these to suit your own requirements, and you can add as many extra Labels as you need.

The code works on the basis of creating a "FormLabel" Class for each Label on the UserForm, and then incorporating all of those Classes into a Collection.

Hope this helps - please let me know how you get on.

Regards,

Greg M