Control Source property of a Label control

[vijay]

Hi,
Can I set the 'control source' property to a label and if not how can i acheive a dynamic label without using Form Event handlers, where in the label's text change based on some criteria.

Thanks,
vijay.

 

[Tom Urtis]

Labels do not have a "control source" property. You can tie their Caption property (the text you want the lable to display) to whatever event is occurring that is changing.

Example, if you want Label1 to display whatever is being entered in TextBox1, this would do that:

Private Sub TextBox1_Change()
Label1.Caption = TextBox1.Text
End Sub

 

[vijay]

Thanks. But I want my label control to display caption based on a value in a cell in a xl sheet. Also, i can't use any event handlers (as textbox1_change()) according to my requirement. Is there any alternative solution.

 

[Tom Urtis]

What kind of label is this (ActiveX or Forms), and where is it...on the sheet or in a userform?

 

[vijay]

Its an Form Label and is present in a userform.

 

[Tom Urtis]

Well, if it's in a userform then it's an ActiveX object.

I don't know what you mean by not being able to use event handlers seeing as you are using event-driven ActiveX objects such as Label controls in a userform.

Since you are calling a userform you can use the Initialize event to see a cell's value in the Label when you call the userform. This would do that, assuming your Label control is named "Label1" (you have not yet said what its name is) and the cell of interest is A1 (you have not yet said what cell you have in mind).

This goes in the userform module:

Private Sub UserForm_Initialize()
Label1.Caption = Range("A1").Value
End Sub



Then again, if your userform is modeless and you want the Label caption handled when someone enters a new value in cell A1 when the userform is visible, it will require a Change event in the worksheet module.

If for whatever reason you are against invoking any events, you are out of luck.