Sub New_Name()
Dim tName
tName = Application.InputBox(Enter New Name)
Range(A1).Value = tName
End Sub
Note, I would be CAUTIOUS of using a keyword like Name
as a variable.
Excel uses it for SO many things. It could get confusing
Paul
From: Tommy jntwh...@verizon.net
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Mon, November 9, 2009 9:19:46 AM
Subject: $$Excel-Macros$$ InputBox
I need to be able to insert text into a cell using the “inputbox”
function linked to a button. The macro below allows me to input the
text, but getting it to go somewhere eludes me. I realize that
Copy.Name doesn't work but how do i direct the entered text to a
cell? Suggestions appreciated.
Tommy
Sub New_Name()
Name = Application.InputBox(Enter New Name)
Copy.Name
Range(A1).Select
ActiveSheet.Paste
End Sub
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends and co-workers know they can subscribe to group at
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---