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!


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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 " wrote in
message ...
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!


---
Message posted from http://www.ExcelForum.com/

Binzelli wrote:
*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 " wrot
in
message ...
Hi all,

I have a userform with some textboxes. Does anyone know how to ge
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 i
the
cell after user press the commandbutton. I would like user t
preview it
immediate in the cell as well.

Any advise? Thanks!


---
Message posted from http://www.ExcelForum.com/
*


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

--
Message posted from http://www.ExcelForum.com