View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ksfarmer ksfarmer is offline
external usenet poster
 
Posts: 10
Default Clear value in cell when the "enter" key is pressed

I have a work area of 4 columns wide and 60 rows long
I need the following macro

1. I enter numbers in column A1
2. Accumulate them in Column B1
3. Clear the value in Column A1 when "enter" key is pressed
4. Enter a new number in Column A1
5. Acumulate that in Column B1
6. Clear the value in Column A1 when the "enter" key is pressed
7 repeat as data entry requires.

This same routine would be applied to A2-B2 through row A60-B60

Any help appreciated..