Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 "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?? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Excel Macro Issue Trying to autorun Macro Upon Opening Worksheet | Excel Programming |