Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to rotating a Label control in VB 6.0 to, say 90 or -90 degrees | Excel Programming | |||
Cancel Click on label control | Excel Programming | |||
label control from macro | Excel Programming | |||
Is it possible to Link a Label control to a cell ? | Excel Worksheet Functions | |||
Label control - suppress GetFocus | Excel Programming |