ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UserForm Text Box to display worksheet cell text (https://www.excelbanter.com/excel-programming/441018-userform-text-box-display-worksheet-cell-text.html)

Wmeyer2

UserForm Text Box to display worksheet cell text
 
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

UserForm Text Box to display worksheet cell text
 
The below code will get the cell text to the textbox1 in userform while the
form is activated..Right click the userformView Code and place the below
code ..

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



--
Jacob


"Wmeyer2" wrote:

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



All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com