I
I
IceSn1per2014-10-27 15:14:52
Visual Basic
IceSn1per, 2014-10-27 15:14:52

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

1 answer(s)
A
Anton Fedoryan, 2014-11-25
@AnnTHony

A month late, but still:

Private Sub CommandButton1_Click()
    Cells(1, 1).Value = TextBox1.Text
End Sub

Examples

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question