VBA / Excel .... put text-box value into cell

[rickgalty]

Hi, if I write a quick pop-up form in VBA, how do I then move a string value from a text-box on the form to a cell on the Excel workbook?

Richard

 

[firefytr]

Hi there Richard,

If you have just a message box ...

Dim Msg as vbmsgboxresult
Msg = Msgbox("Enter value:")
If Msg <> "" then Range("A1").value = Msg

.. if you have a userform, use the event/objects code ...

Range("A1").value = Me.TextBox1.Value

Replace the range/object for your specific situation.

HTH

Regards,
Zack Barresse

 

[rickgalty]

Thank you very much !

Richard