I have a userform with multiple textboxes on it. When the user clicks on a textbox, a short description for that particular textbox appears in a label. The text inside the label changes depending on which textbox is clicked on.
For example:
Private Sub TextBox2_enter()
UserForm1.Label82.Caption = "The vertical distance from finished grade to the eave."
end sub
I also want to copy the contents of that textbox to a cell on the worksheet but because of the enter event associated with the textbox, the only way the text is copied into the cell is if the user clicks back on the textbox. How can I change this so the text is copied to the cell at the same time that it is typed into the textbox?
For example:
Private Sub TextBox2_enter()
UserForm1.Label82.Caption = "The vertical distance from finished grade to the eave."
end sub
I also want to copy the contents of that textbox to a cell on the worksheet but because of the enter event associated with the textbox, the only way the text is copied into the cell is if the user clicks back on the textbox. How can I change this so the text is copied to the cell at the same time that it is typed into the textbox?
