Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
how to change data in worksheet in text without confirming each s. | Excel Discussion (Misc queries) | |||
HOW CAN I AUTO FILL A CELL WITH TEXT FROM ANOTHER WORKSHEET TEXT . | Excel Worksheet Functions | |||
Bring all text from "Text" worksheet | Excel Discussion (Misc queries) | |||
Match text to another worksheet and return a certain value | Excel Worksheet Functions |