LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8,520
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I display Unicode Text on UserForm.Caption Zoo Excel Programming 0 October 1st 07 08:26 AM
Having a cell display certain text or formatting when the worksheet is protected or unprotected jonco Excel Programming 4 July 4th 06 02:41 PM
Find text within cell then display text to left Jambruins Excel Discussion (Misc queries) 5 April 17th 06 10:01 PM
Qn: Display Text in TextBox in Userform Michael Vaughan Excel Programming 1 August 18th 04 05:06 PM
UserForm - display text message then run code Robert[_13_] Excel Programming 3 September 13th 03 11:37 AM


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"