Userform Label Click problem

[shanec]

i have created some dynamic labels on a userform however when i go to link them to with let’s say line1_click it does not recognize it albeit i know that label is definitely there. Is there a setting or something i am missing in the properties.

This is how the label is created

Set newlabel = Statistics_Form3.Controls.Add("Forms.label.1", "line" & labelnumber, True)


thanks for looking at this

Shanec

 

[MacroEcon1337]

thanxsssss, eres genial colin. I register only for thanks you. .... mmm post from 2007. Hope you didnt died from covid or something

I likewise/in-turn reset my account credentials to respond to this hilarious expression of gratitude. And also because its true. The solution provided by the genial colin still works in 2023 on latest excel 365. His elegant concise class code is all you need. The userform examples looks intimidating but its just to demonstrate. Like five seconds and done. Raising my glass to the genial colins, send proof of life good sir!!!!