Automatically entering data in cells
 

I'm sorry if this has been posted before, but I am having difficulty
finding an answer that works for me. I'd like to write a simple excel
file that would do 3 things.

1) Automatically fill in the next sequential row number every time a
cell is selected in the A column. ie. after filling row #1 with data
and hitting enter, cell A2 would automatically fill with the number 2,
and then, after hitting enter, A3 would automatically fill with the
number 3, etc.

2) Automatically fill in today's date (static, so that the value will
not change tomorrow) every time a cell is selected in the B column.
I've tried adding a couple different versions of macros/module to the
VBAproject, but I'm having difficulty getting that to work, and perhaps
I need step-by-step directions. One thing I didn't understand is, does
a macro have to be manually started (ie. ToolsMacroMacrosRun) every
time you select a cell in order for it to run?

3) Automatically fill in a word every time a cell is selected in the C
column, such that if I hit Tab the word will remain or if I hit
Backspace I can type in a different word.

I'm pretty new to Excel, so I'm hoping these are easy questions!

Thanx for your help

- Scott


--
dipdog
------------------------------------------------------------------------
dipdog's Profile: http://www.excelforum.com/member.php...o&userid=37607
View this thread: http://www.excelforum.com/showthread...hreadid=572277