Label Control
Hello.
I created a user form in Excel Vb. It has about 70 labels. Code should know which label is triggered by mousemove event. Information is queried from sheets by using label.name string and the informations are shown in yellow baloons on the label. Is it possible to do that easily ? Thanks in advance. |
Label Control
You could make an array of the labels which get update
UpdateLabels = Array("Label1", "Label6","Label8") for each lbl in UpdateLabels Set Cntl = UserForm1.Controls(lbl) Set Lblobj = Cntl.Object Lblobj.Caption = "Joel" next lbl "Murat" wrote: Hello. I created a user form in Excel Vb. It has about 70 labels. Code should know which label is triggered by mousemove event. Information is queried from sheets by using label.name string and the informations are shown in yellow baloons on the label. Is it possible to do that easily ? Thanks in advance. |
All times are GMT +1. The time now is 08:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com