Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding to a number already in a cell
As an example for Cell B9, paste this in the sheet code for that sheet.
Private Sub Worksheet_Change(ByVal Target As Range) Dim sform As String If Target.Count 1 Then Exit Sub If Target.Address = "$B$9" Then If Target.Value = "" Then Exit Sub Application.EnableEvents = False sVal = Trim(Target.Text) Application.Undo If Not IsNumeric(sVal) Then _ GoTo Errhandler sform = Target.Formula If Left(sform, 1) < "=" Then sform = "=" & sform & "+" & sVal Else sform = sform & "+" & sVal End If Target.Formula = sform End If Errhandler: Application.EnableEvents = True End Sub Now if you enter values in B9, it will do what you describe. Lightly tested, but represents the basic approach. -- Regards, Tom Ogilvy "conrad" wrote in message ... I am working on a basic worksheet. I have several numbers which I have to add additional number to in that cell. I want the cell to reflect the total and the display of the cell contents to list the individual numbers added. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding number within a cell | Excel Worksheet Functions | |||
Adding a number to a cell that already has a number. | Excel Discussion (Misc queries) | |||
macro adding a number to a number already in a cell | Excel Programming | |||
macro adding a number to a number already in a cell | Excel Programming | |||
macro adding a number to a number already in a cell | Excel Programming |