Date & Time stamp VB script

[Jeff930]

I need to create an excel sheet in 2003 with a vb script that when I enter text & numbers in columns B, C, D, E, F, etc. it creates a date and time stamp in column A. Sorry, I guess I'm in the right place to post this. If not please redirect. Thank you.

[YasserKhalil]

May be something like that

Please Login or Register  to view this content.

Where 2 reppresents column B and 6 for column F
you can change to suit

[Jeff930]

Thank you that works very well. Just one question. How can I get row A1 cleared for the title of the form, and start the script working exactly the same starting at at A2?

[YasserKhalil]

Please Login or Register  to view this content.

[Jeff930]

Perfect. Now for a really novice question. When I go to save my file it says "the following features from your workbook will not be saved into the XML spreadheet: VB Project Do you want to continue saving as an XML spreadsheet?" What am In doing wrong here? Thank you.

[Jeff930]

Sorry, I am new to this. It works perfect, got the Title to the sheet in A1, and the rest of theet works. However, I forgot that in A2 row I need to put column headers. Thank you.

[YasserKhalil]

Perfect. Now for a really novice question. When I go to save my file it says "the following features from your workbook will not be saved into the XML spreadheet: VB Project Do you want to continue saving as an XML spreadsheet?" What am In doing wrong here? Thank you.

Click No and choose from field Save as type : Excel Macro-Enabled Workbook to be able to save the vba codes ..