I have had trouble with textbox text to worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 
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
 
You must log in or register to reply here.

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

Add Value from Textbox to next cell in range 2
Link a textbox on a sheet to a cell?! 2
Text Box 4
Textbox Formatting 3
WordWrap a TextBox on a UserForm 2
Userform Textbox to Worksheet Textbox 1
Macro: Copy a worksheet and rename it to a specified value 2
Textbox linked to a cell 2

Back
Top