Hello all, I would like to know how to use label and textbox added through frame (ActiveX control) to link to certain cells. please have a look at the attached.
Any help/suggestion would be appreciated.
Hello all, I would like to know how to use label and textbox added through frame (ActiveX control) to link to certain cells. please have a look at the attached.
Any help/suggestion would be appreciated.
Got it,
[VBA]Private Sub Frame1_Click()
Sheets("Sheet1").Frame1.Controls("Label1").Caption = Sheets("Sheet1").Range("A1")
Sheets("Sheet1").Range("A2") = Sheets("Sheet1").Frame1.Controls("TextBox1").Text
End Sub[/VBA]