Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
% Change calculation
Can anybody help me with this macro:
Sub Variance1() Dim exptype exptype = InputBox("Enter e if expense type, else blank.") Dim Actual Actual = InputBox("Select cell for Actual data.") Dim Std Std = InputBox("Select cell for Standard data.") If exptype = "e" Then ActiveCell.Formula = "=-(Actual/Std-1)" Else ActiveCell.Formula = "=Actual/Std-1" End If Selection.Style = "Percent" End Sub I want Actual & Std to be the cell address of my selected cells Am new to excel & not familiar with input box, specially cell addresses Thxs Al |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simple calculation where values change to letters? | Excel Worksheet Functions | |||
Calculation options change arbitrarily | Excel Worksheet Functions | |||
the calculation tab being changed and you didn't change it? | Excel Discussion (Misc queries) | |||
why does the calculation summery not change | Excel Discussion (Misc queries) | |||
How do I make the now() static and not change with calculation? | Excel Worksheet Functions |