View original (French)

VBA: Put in a cell information entered in a userform

Solved
Tagazock Posted messages 2 Status Member -  
 landrydeco -
Hello,
Here is my question:
I would like to put in an Excel cell an entry made by an operator in a userform.
Let me explain a bit better
A userform will be opened with a choice to make on a modifiable text area as well as a quantity to enter.
It would be necessary, once the choice is made, for the information entered to be placed in specific cells.

I hope my question is clear and thank you for your responses.
Best regards

Configuration: Windows 8 / Firefox 21.0

1 answer

  1.
    zebulon2503 Posted messages 1229 Registration date   Status Member Last intervention   110
     
    Hi

    here's the code to fill a cell (for example B2) : 

    Sub Test() --> procedure Range("B2").Value = UserForm1.TextBox1.Value End Sub --> end of procedure


    This is the base code if you have a user form named UserForm1 (default name at creation) containing a text field named "TextBox1" (default name as well).

    Is that enough? :-)
    4
    1. landrydeco
       
      In order to master the codes in the userform, can I get a link to courses that describe the different codes to use in a form?
      0