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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top