Type in textbox display immediately in cell - need help on this

H

HappyDevil24

Hi all,

I have a userform with some textboxes. Does anyone know how to get what
type in the textboxes and quickly reflect in a selected cell?

Current, I can only get the value or text in the textbox and put in the
cell after user press the commandbutton. I would like user to preview it
immediate in the cell as well.

Any advise? Thanks!
 
M

mangesh_yadav

For the concerned textbox, write the code for inserting th
textbox.value to the required cell, in its (textbox's) "Change" o
"Exit" event.

Manges
 
B

Binzelli

If I understand your question correctly, you want to put the value of a
textbox on a form directly in a cell as it changes !?

If that's the case, use the _Change event of the textbox, for example for a
textbox called "txtStart":


Private Sub txtStart_Change()

ActiveSheet.Range("A1").Value = txtStart.Text

End Sub


Good luck
 
H

HappyDevil24

Binzelli said:
*If I understand your question correctly, you want to put the valu
of a
textbox on a form directly in a cell as it changes !?

If that's the case, use the _Change event of the textbox, for exampl
for a
textbox called "txtStart":


Private Sub txtStart_Change()

ActiveSheet.Range("A1").Value = txtStart.Text

End Sub


Good luck

"HappyDevil24 >" <<[email protected]> wrot
in
message news:[email protected]...
Click to expand...


Thanks guys. I just found this Change event last nite ;
 
Top