Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - msgbox vs. enter result in a cell??/
A kind soul wrote this subroutine to display the result of an equation in a message box. 1) If I want to display the result of the equation in cell A2, instead of the message box, how do I change the subroutine, below? what is the code to actually enter the value in a cell? 2) If I want to continue down the columns (C, E, F) until there are no more entries, how would I write that?? (size of the columns vary from 29-100 + entries) Thanks Dim vResult As Variant vResult = IIf(Range("E2") = 0, _ "? RT = " & Format(Range("F2"), "###.00"), _ Range("C2").Value) MsgBox vResult End Sub |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro - msgbox vs. enter result in a cell??/
range("c3").value=IIf(Range("E2") = 0, _
"? RT = " & Format(Range("F2"), "###.00"), _ Range("C2").Value) -- Don Guillett SalesAid Software wrote in message oups.com... A kind soul wrote this subroutine to display the result of an equation in a message box. 1) If I want to display the result of the equation in cell A2, instead of the message box, how do I change the subroutine, below? what is the code to actually enter the value in a cell? 2) If I want to continue down the columns (C, E, F) until there are no more entries, how would I write that?? (size of the columns vary from 29-100 + entries) Thanks Dim vResult As Variant vResult = IIf(Range("E2") = 0, _ "? RT = " & Format(Range("F2"), "###.00"), _ Range("C2").Value) MsgBox vResult End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enter value, convert, read result from same cell | Excel Discussion (Misc queries) | |||
Enter data and display function result in same cell | Excel Discussion (Misc queries) | |||
MsgBox in ComboBox Enter Event does not allow update | Excel Programming | |||
Enter a formula to return a result from a cell | New Users to Excel | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |