Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell format and Calculation
I want to enter a number into a cell and this number will automatically add
its value into another cell. However, after the pressing the enter key, I want the entered number to be disappeared, leaving room for the next number. How can I accomplish this? Or is this possible? |
#2
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell format and Calculation
Try putting this into the worksheet code where you want this to occur, the
input cell is A1 the summation cell is B1 Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1").Value 0 Then Range("B1").Value = Range("B1").Value + Range("A1").Value Range("A1").Value = "" End If End Sub Cheers Nigel "Raymond" wrote in message ... I want to enter a number into a cell and this number will automatically add its value into another cell. However, after the pressing the enter key, I want the entered number to be disappeared, leaving room for the next number. How can I accomplish this? Or is this possible? |
#3
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell format and Calculation
I am not a programer. How do it open the cell code and put this in there?
Thanks. "Nigel" wrote in message ... Try putting this into the worksheet code where you want this to occur, the input cell is A1 the summation cell is B1 Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1").Value 0 Then Range("B1").Value = Range("B1").Value + Range("A1").Value Range("A1").Value = "" End If End Sub Cheers Nigel "Raymond" wrote in message ... I want to enter a number into a cell and this number will automatically add its value into another cell. However, after the pressing the enter key, I want the entered number to be disappeared, leaving room for the next number. How can I accomplish this? Or is this possible? |
#4
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell format and Calculation
From Excel press Alt-F11 to open the VBA editor. Then press Ctrl R to open
the Project Viewer. This lists the object in the workbook. Double Click the worksheet into which you wish to apply this programme. Paste the entire code in the new window that opended. Close the VBA editor and try it. You can edit the cells etc., by re-opening the code as above and changing the range values A1 and B1 as required. Cheers Nigel "Raymond" wrote in message ... I am not a programer. How do it open the cell code and put this in there? Thanks. "Nigel" wrote in message ... Try putting this into the worksheet code where you want this to occur, the input cell is A1 the summation cell is B1 Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1").Value 0 Then Range("B1").Value = Range("B1").Value + Range("A1").Value Range("A1").Value = "" End If End Sub Cheers Nigel "Raymond" wrote in message ... I want to enter a number into a cell and this number will automatically add its value into another cell. However, after the pressing the enter key, I want the entered number to be disappeared, leaving room for the next number. How can I accomplish this? Or is this possible? |
#5
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell format and Calculation
and if you make a mistake entering the number, what do you want to have
happen (if you forget what number you entered; but you know it is wrong, then what). Generally a running total with no audit trail can be problematic. -- Regards, Tom Ogilvy "Raymond" wrote in message ... I am not a programer. How do it open the cell code and put this in there? Thanks. "Nigel" wrote in message ... Try putting this into the worksheet code where you want this to occur, the input cell is A1 the summation cell is B1 Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1").Value 0 Then Range("B1").Value = Range("B1").Value + Range("A1").Value Range("A1").Value = "" End If End Sub Cheers Nigel "Raymond" wrote in message ... I want to enter a number into a cell and this number will automatically add its value into another cell. However, after the pressing the enter key, I want the entered number to be disappeared, leaving room for the next number. How can I accomplish this? Or is this possible? |
#6
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell format and Calculation
It's easier to right click on the sheet tab, select View Code, and pop
the macro in there. Pay heed to Tom's astute observation, as well. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Nigel wrote: From Excel press Alt-F11 to open the VBA editor. Then press Ctrl R to open the Project Viewer. This lists the object in the workbook. Double Click the worksheet into which you wish to apply this programme. Paste the entire code in the new window that opended. Close the VBA editor and try it. You can edit the cells etc., by re-opening the code as above and changing the range values A1 and B1 as required. Cheers Nigel "Raymond" wrote in message ... I am not a programer. How do it open the cell code and put this in there? Thanks. "Nigel" wrote in message ... Try putting this into the worksheet code where you want this to occur, the input cell is A1 the summation cell is B1 Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Range("A1").Value 0 Then Range("B1").Value = Range("B1").Value + Range("A1").Value Range("A1").Value = "" End If End Sub Cheers Nigel "Raymond" wrote in message ... I want to enter a number into a cell and this number will automatically add its value into another cell. However, after the pressing the enter key, I want the entered number to be disappeared, leaving room for the next number. How can I accomplish this? Or is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculation / Format Error | Excel Worksheet Functions | |||
Cell format to use for calculation | Excel Worksheet Functions | |||
Calculation based on cell format results | Excel Discussion (Misc queries) | |||
Hours calculation in 24h format | Excel Discussion (Misc queries) | |||
format to calculation cell | Excel Discussion (Misc queries) |