Label Control

  • Thread starter Thread starter Murat
  • Start date Start date
M

Murat

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.
 
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
 
Back
Top