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

[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!

 

[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

 

[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

 

[HappyDevil24]

*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]...

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