VBA: Taking text typed into an Input Box and pasting it into a specific cell

C

cparaske

I've been trying to take information typed into an input box and havin
Excel then paste it into a specified cell on a worksheet. Does anyon
know what the code to do this is?

Literally can't get past:
nameses=inputbox("X","X"
 
J

J.E. McGimpsey

one way:

Dim nameses As String
nameses = InputBox("X", "X")
Sheets("Sheet1").Range("A1").Value = nameses
 

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

Pasting a cell into bookmarked table from excel vba 1
VBA Macro - Copying specific data to different sheets in a workbookand linking the InputBox to a com 7
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Need help modifying code 0
nk into onenote 2016 paragraph from excel 2016 cell 0
Copy, paste to active workbook? 1
Creating Labels Over 3-Up Image 2
VBA - (re-) Set a Table Style 2

Top