View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
 
Posts: 364
Default 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??