Samanathon
New Member
- Joined
- Apr 22, 2002
- Messages
- 12
Okey, here is the deal:
I have made a Userform that includes 3 text boxes that a user would input info into (the userform has "OK" & "Cancel" buttons as well).
When the "OK" button is clicked, the code will insert a new row (lets say row A) and input the info from the text boxes in the cells (A1, A2, A3).
What command would I use to take the info (that that the user inputted into the text boxes) and place them into the new A1, A2 & A3 cells?
------------------------
I have programed the Userform to insert that new row as soon as the button that activates the userform is press, but I don't think that I would like keep it like this - because the cancel button doesn't undo the insert . . .
-Thanks!!!
Samanathon
I have made a Userform that includes 3 text boxes that a user would input info into (the userform has "OK" & "Cancel" buttons as well).
When the "OK" button is clicked, the code will insert a new row (lets say row A) and input the info from the text boxes in the cells (A1, A2, A3).
What command would I use to take the info (that that the user inputted into the text boxes) and place them into the new A1, A2 & A3 cells?
------------------------
I have programed the Userform to insert that new row as soon as the button that activates the userform is press, but I don't think that I would like keep it like this - because the cancel button doesn't undo the insert . . .
-Thanks!!!
Samanathon