UserForm Text Box to display worksheet cell text

[Wmeyer2]

I need a way to display the content of my worksheet cell text 'Site Data' B:1
on a UserForm named LocalizerRef.
Thanks in advance for any assitance you may render (please try to not laugh
too loudly)
Bill

 

[Jacob Skaria]

The below code will get the cell text to the textbox1 in userform while the
form is activated..Right click the userform>View Code and place the below
code ..

Private Sub LocalizerRef_Activate()
Me.TextBox1 = ThisWorkbook.Sheets("Site Data").Range("B1")
End Sub