UserForm Text Box to display worksheet cell text

W

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
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

UserForm as Reader 3
Simply show UserForm 5
Userform Combo box to mimick Worksheet Cell validation list range. 2
VBA userform Vlookup Excel 1
Allow text in locked cells on a worksheet from a userform 16
display $ in a userform textbox 2
Copy Userform ListBox AND TextBox values 1
UserForm-Insert value from diff worksheet into text box upon initi 3

Top