Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Calculating in the same cell
Is it possible to enter a number into a cell, have it multiplied by a
specified number, and the result automatically placed in the same cell? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Calculating in the same cell
Hi,
Something along these lines : Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False Set Target = Range("a1") Target.Value = Target.Value * 3 Application.EnableEvents = True End Sub HTH Carim |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Calculating in the same cell
Oops,
Forgot to restrict to range("A1") Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub Else Application.EnableEvents = False Target.Value = Target.Value * 3 Application.EnableEvents = True End If End Sub Carim |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Calculating in the same cell
Oops,
Forgot to restrict area to range("A1") Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("A1")) Is Nothing Then Exit Sub Else Application.EnableEvents = False Target.Value = Target.Value * 3 Application.EnableEvents = True End If End Sub Carim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating from last inputted cell | New Users to Excel | |||
Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
Cell reference in the auto filter custom list | Excel Discussion (Misc queries) | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Can a cell have a drop down list and can also be auto populated | Excel Worksheet Functions |