Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a while loop for formulas?
Someone help me out. I have a few different equations that require iteration
in order to solve. The variable within the equations are based off of inputed data by the user. Is there any way that I can create a while loop within excel to calculate the values that I need? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a while loop for formulas?
are you looking for something like
Do while x < 125 ' code Loop -- steveB Remove "AYN" from email to respond "frustrated" wrote in message ... Someone help me out. I have a few different equations that require iteration in order to solve. The variable within the equations are based off of inputed data by the user. Is there any way that I can create a while loop within excel to calculate the values that I need? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I set up a while loop for formulas?
First, you need to be more specific with your question. It is extremily hard
to understand what you want done. Also, I would recommend leaving out lines like " Is there any way that I can create a while loop within excel to calculate the values that I need?", but rather simply state what you want done. It just makes it easier to come up with a solution for you. Now on to your problem. If I understand you correctly, you want to take data imputed by the user and process it inside an equation? If this is the case you can just use an inputbox function. Value1 = InputBox("Enter Value 1:") Value2 = InputBox("Enter Value 2:") Solution = Value1*Value2 If you have multiple values to enter at once, you can add a while loop and modify the last value with a vbhYesNo. "frustrated" wrote: Someone help me out. I have a few different equations that require iteration in order to solve. The variable within the equations are based off of inputed data by the user. Is there any way that I can create a while loop within excel to calculate the values that I need? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find loop doesn't loop | Excel Discussion (Misc queries) | |||
Problem adding charts using Do-Loop Until loop | Excel Programming | |||
How do I create a For loop within a For loop? | Excel Programming | |||
Macro to move, create formulas and loop | Excel Programming | |||
HELP!!!! Can't stop a loop (NOT an infinite loop) | Excel Programming |