Answer the question
In order to leave comments, you need to log in
Enter values in UserForm and send them to certain cells by button (VBA)?
Hello! =)
Help with solving the problem ..
It is necessary to develop a student form, where it fits: full name, class number, marks (how many 5, how many 4, etc.).
Everything needs to be done through the UserForm, but I can’t figure out how to make a function so that, on pressing a button, all information from all TextBoxes is written to certain cells (the cell is set in the code itself)
Please help me how to implement all this
Answer the question
In order to leave comments, you need to log in
A month late, but still:
Private Sub CommandButton1_Click()
Cells(1, 1).Value = TextBox1.Text
End Sub
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question