Posted by Jeff on November 09, 2000 6:10 PM
I am trying to create a macro that will accept a numerical value for "number of variables," assign letters for those variables (var1 = a, var2 = b, etc...) and further textual values (english statements) to those variables.
Here is my code
Vars = InputBox("How many variables are in the statement? (Note: Variables will be named in descending order beginning with 'a.'", "Step One", 2)
For Cols = 1 To Vars
Var1 = InputBox("Let variable " & (Cols) & "=", Type:=2)
ActiveCell.Formula = Var1