View Single Post
 
Old 08-17-2006, 08:37 AM
dipdog dipdog is offline
Novice
 
Join Date: Aug 2006
Posts: 1
dipdog
Default Automatically entering/fill data in cells in Excel 2003

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. Tools>Macro>Macros>Run) 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 a novice with Excel, so I'm hoping these are easy questions!

Thanx for your help

- Scott
Reply With Quote