excel vba macro Please HELP!!!
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??
|