Prev: Code to update links every 30 seconds
Next: Protecting macros
From: Wmeyer2 on 25 Mar 2010 04:31
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
From: Jacob Skaria on 25 Mar 2010 04:44
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



--
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
 | 
Pages: 1
Prev: Code to update links every 30 seconds
Next: Protecting macros