excel vba macro Please HELP!!!

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
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
 
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
 
Ahhh... Gary I got it to work.. .Ignore my last message.. Thank you so much -
you saved the day!!! It works like a charm - Thank you so much for your help
- I can not thank you enough -3 days and many long hours and cups of coffee
trying to get this stupid thing to work - and you got the right answer for
me in minutes..

Thank you so very much - I appreciate this so much!!
You saved the day!!! Again, I am very thankful!

Nadine
 
Back
Top