textbox contents to a cell

  • Thread starter Thread starter Bob Leathers
  • Start date Start date
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Incorpoarting cell contents into a message box 6
Move cell contents with macro 4
Excel Displaying content from excel sheet onto textbox in userform 0
HELP! Split cell contents to new rows 7
pasting content copied from nonadajacent cells 1
Display text box contents in cell 1
Excel Data pastes into 2 cells not 1 1
Excel Selected Cell's Content Magnification 3

Back
Top