I tried to run it like that but, it keeps coming up with an application
error. I need my macro to have an input box that askes for "Customer Name"
and then takes the result that is inputted (inot the input box) and puts it
into cell C5?

I can not get it to work?

Nadine



"Gary Keramidas" wrote:

check out the help for the type of data you are returning, the 1 in my code
returns a number

Sub test()
worksheets("sheet1").Range("c5").Value = Application.InputBox("Enter your
response", "Data Entry", , _
, , , , 1)

End Sub

--


Gary

"Nadine needs help!!" <Nadine needs wrote
in message ...
I need help with a VBA macro.

I want the macro to ask an "Iresponse" question with a input box and then
the answer of this question to be put into a certin cell "C5"
I then need to ask another question and have that answer put into a
different cell "C6"

I want another macro to ask a questions and if the answer is yes then it
automatically calulates a value in a cell. ex. (A10*1.07) and put that
value
into a different cell A12

Any one who can pretty please help me??? this is for work and I have a due
date - YIKES??