Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Thomas
 
Posts: n/a
Default I have had trouble with textbox text to worksheet

I am having trouble with textboxes in my userform. I would like to copy the
text from several textbox in the userform I set up in Visual Basic into the
proper cells on my worksheet. I have tried a couple of different ways but I
must be missing a step. Can anyone help???
  #2   Report Post  
OJ
 
Posts: n/a
Default

Hi,
assuming you want to do it on the click of a button then..

Private Sub CommandButton1_Click()
ThisWorkbook.Sheets(1).Cells(1, 1).Value = Me.TextBox1.Value
End Sub

Where TextBox1 is your textbox...

Hth,
Oli

Reply
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
Weekly Transaction Processing Ralph Howarth Excel Worksheet Functions 4 January 19th 05 05:37 AM
how to change data in worksheet in text without confirming each s. Ronald Excel Discussion (Misc queries) 1 January 17th 05 08:27 AM
HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . waz Excel Worksheet Functions 2 December 29th 04 07:49 PM
Bring all text from "Text" worksheet Dradin Excel Discussion (Misc queries) 1 December 27th 04 08:37 PM
Match text to another worksheet and return a certain value Edye Excel Worksheet Functions 4 December 19th 04 04:53 PM


All times are GMT +1. The time now is 11:17 AM.

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

About Us

"It's about Microsoft Excel"