About Us

Greg B[_5_]

How do I get this to place information onto a work sheet called committee
cell b10?

Private Sub CommandButton9_Click()
Dim MyInput
MyInput = InputBox("Enter your name")
MsgBox MyInput

End Sub

Thanks
Greg

Paul B

Greg, here is one way,
Sheets("committee").Range("B10") = InputBox("Enter your name")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Greg B" wrote in message
...
How do I get this to place information onto a work sheet called committee
cell b10?

Private Sub CommandButton9_Click()
Dim MyInput
MyInput = InputBox("Enter your name")
MsgBox MyInput

End Sub

Thanks
Greg

Greg B[_5_]

OK Thanks for your help

Greg
"Paul B" wrote in message
...
Greg, here is one way,
Sheets("committee").Range("B10") = InputBox("Enter your name")

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Greg B" wrote in message
...
How do I get this to place information onto a work sheet called
committee
cell b10?

Private Sub CommandButton9_Click()
Dim MyInput
MyInput = InputBox("Enter your name")
MsgBox MyInput

End Sub

Thanks
Greg

Bob Phillips[_6_]

Worksheets("committee").Range("B10").Value = MyInput

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Greg B" wrote in message
...
How do I get this to place information onto a work sheet called committee
cell b10?

Private Sub CommandButton9_Click()
Dim MyInput
MyInput = InputBox("Enter your name")
MsgBox MyInput

End Sub

Thanks
Greg

Greg B[_5_]

Thanks to both of you for the help

Greg
"Bob Phillips" wrote in message
...
Worksheets("committee").Range("B10").Value = MyInput

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Greg B" wrote in message
...
How do I get this to place information onto a work sheet called
committee
cell b10?

Private Sub CommandButton9_Click()
Dim MyInput
MyInput = InputBox("Enter your name")
MsgBox MyInput

End Sub

Thanks
Greg

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to input pictures automatically based on cell input?	bsharp	Excel Worksheet Functions	9	May 30th 09 07:16 AM
input in number form is being multiplied by 1000 when i input.	jweinograd	Excel Discussion (Misc queries)	4	April 16th 07 11:18 PM
Have user input converted to uppercase in same cell as input?	Shannonn	New Users to Excel	1	June 20th 06 03:19 AM
How do I add input data in the input ranges in drop down boxes.	oil_driller	Excel Discussion (Misc queries)	1	November 9th 05 10:31 PM
CODE to select range based on User Input or Value of Input Field	Sandi Gauthier	Excel Programming	4	December 8th 03 03:22 PM

Menu

About Us