Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EnableEvent On Change
It's obvious i haven't understood this situation where a change, causes a
change, which causes a change -- of course this is happening due to my line: Target.Value = Target.Value * 1.06 If I enter 100 in cell D6 - the system goes wild and produces 102,461.64 versus my expected 106. Help with this would be appreciated. TIA, Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("D5:G10")) Is Nothing Then Exit Sub Else Target.Value = Target.Value * 1.06 End If End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change scaling % but font size didnt change porportionally, pls he | Excel Discussion (Misc queries) | |||
Excel bar chart formatting of bars to change colors as data change | Excel Discussion (Misc queries) | |||
Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming |