Hi if you could help me to Complete the code 3 cells USERFORM to enroll in one cell in excel.
Call button in excel UserForm.
Cancel - button works
ADD - button -> pressed it to my cell transfer in anything written. For example, if a cell is a UserForm is not written, then in excel cell carries the rest.
I will attach the excel file and image to be seen.
Thanks in advance.
You don't say which cell to use for the destination on the sheet, nor do you say which 3 of the 4 textboxes you want to use, so I've guessed:[VBA]Private Sub CommandButton1_Click()
With ActiveSheet
.Cells(.Rows.Count, "A").End(xlUp).Offset(1).Value = Application.Trim(Join(Array(TextBox1.Text, Me.TextBox2.Text, Me.TextBox3.Text)))
End With
End Sub
[/VBA]
p45cal Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
Hello p45cal, I was so tired that she had a typo when writing. Do not worry, I have set the column and I type the 4 cell.
Many thanks for the quick response from your side.
Be alive and well.
Рegards
Posting Permissions
Reply With Quote
