PDA

View Full Version : Solved: Label and textbox on microsoft Forms 2.0 Frame



copyt
04-08-2012, 02:18 PM
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. :bow:

copyt
04-08-2012, 03:29 PM
Got it,

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