UserForm Text Box to display worksheet cell text

  • Thread starter Thread starter Wmeyer2
  • Start date Start date
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
 
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
Displaying userform before worksheet displays 4
VBA userform Vlookup Excel 1
Simply show UserForm 5
Hidden sheet bleeds through 3
Userform Combo box to mimick Worksheet Cell validation list range. 2
Allow text in locked cells on a worksheet from a userform 16
Excel data display userform problem 3

Back
Top