textbox contents to a cell

B

Bob Leathers

How can I take the contents of a text box in a user form an put it into
a cell? Seems like everything I try fails.

Thanks
 
H

Harald Staff

Hi

Depends on what "a cell" is. If it's B1 on sheet 2 then
Sheets("Sheet2").Range("B1").Value = Textbox1.Text

if it's "wherever my cursor was the last time I saw it" then it's
ActiveCell.Value = Textbox1.Text

You're welcome
 
Top