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
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.