Consulting

Results 1 to 2 of 2

Thread: Solved: Label and textbox on microsoft Forms 2.0 Frame

  1. #1

    Solved: Label and textbox on microsoft Forms 2.0 Frame

    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.
    Attached Files Attached Files

  2. #2
    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]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •