Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Input Box results in a formula
Hi, I was hoping someone could help me.
I've got a macro that asks the user for two inputs, defined as MyValue and MyValue2. How do I use the results in a formula though? This is the code that I have currently: MyValue1 = Application.InputBox("How many days is the current event?") MyValue2 = Application.InputBox("How far through the current even are you?") Range("Y1").Select ActiveCell.FormulaR1C1 = "=[MyValue1]/[MyValue2]" However, it crashes out on putting the formula in. How do I correctl call the results of MyValue1 & 2 and put them into a formula? Any help greatly appreciated! Thanks, Pau -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Input Box results in a formula
Try this:
Range("Y1").Select ActiveCell.Value = MyValue1/MyValue2 -IA -----Original Message----- Hi, I was hoping someone could help me. I've got a macro that asks the user for two inputs, defined as MyValue1 and MyValue2. How do I use the results in a formula though? This is the code that I have currently: MyValue1 = Application.InputBox("How many days is the current event?") MyValue2 = Application.InputBox("How far through the current event are you?") Range("Y1").Select ActiveCell.FormulaR1C1 = "=[MyValue1]/[MyValue2]" However, it crashes out on putting the formula in. How do I correctly call the results of MyValue1 & 2 and put them into a formula? Any help greatly appreciated! Thanks, Paul --- Message posted from http://www.ExcelForum.com/ . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Input Box results in a formula
Sub dividedays()
Range("b1").Value = InputBox("How many days in event") / InputBox("How far through") End Sub Don Guillett SalesAid Software "PaulSinki" wrote in message ... Hi, I was hoping someone could help me. I've got a macro that asks the user for two inputs, defined as MyValue1 and MyValue2. How do I use the results in a formula though? This is the code that I have currently: MyValue1 = Application.InputBox("How many days is the current event?") MyValue2 = Application.InputBox("How far through the current event are you?") Range("Y1").Select ActiveCell.FormulaR1C1 = "=[MyValue1]/[MyValue2]" However, it crashes out on putting the formula in. How do I correctly call the results of MyValue1 & 2 and put them into a formula? Any help greatly appreciated! Thanks, Paul --- Message posted from http://www.ExcelForum.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using Input Box results in a formula
Paul
Why do you need a formula entered into Y1? You can enter the computed value directly. Public Sub qwerty() Dim MyValue1 As Long Dim MyValue2 As Long MyValue1 = InputBox("How many days is the current event?") MyValue2 = InputBox("How far through the current event are you?") Range("Y1").Select ActiveCell.Value = MyValue1 / MyValue2 End Sub Gord Dibben Excel MVP On Thu, 11 Dec 2003 11:07:59 -0600, PaulSinki wrote: Hi, I was hoping someone could help me. I've got a macro that asks the user for two inputs, defined as MyValue1 and MyValue2. How do I use the results in a formula though? This is the code that I have currently: MyValue1 = Application.InputBox("How many days is the current event?") MyValue2 = Application.InputBox("How far through the current event are you?") Range("Y1").Select ActiveCell.FormulaR1C1 = "=[MyValue1]/[MyValue2]" However, it crashes out on putting the formula in. How do I correctly call the results of MyValue1 & 2 and put them into a formula? Any help greatly appreciated! Thanks, Paul --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When I enter a formula, Excel shows the formula not the results | Excel Worksheet Functions | |||
Input formulas in a defined data range and convert results as valu | New Users to Excel | |||
Multiple input and output results | Excel Discussion (Misc queries) | |||
Calculate multiple results from multiple input values? | Excel Discussion (Misc queries) | |||
how do i input customer information and results of meeting | Excel Worksheet Functions |