Search : in
By :

VBA macro in Excel 2007

ceebass, on Apr 8, 2009 9:19:01 pm BST 
 Report this message to moderators

Hi,

I'm by no means a visual basic expert and I'm trying to write sheet macros to do the following:

1. when data is entered into a cell in Column A, a formula is automatically entered into Column B.
2. when data is entered or changed in any cell in the table (say columns A to G), column H automatically enters the date so that I can tell when that particular row was last edited

I would be ever so grateful for any help anyone could offer with this.

Regards

Ceebass

Configuration: Windows Vista
Firefox 3.0.7

Best answers for « VBA macro in Excel 2007 » in :
VBA macro to move to the cell 'underneath' ShowVBA macro to move to the cell 'underneath' Issue Solution Issue If you need need VBA macro to move to the cell 'underneath' the particular button that is being pressed, series of buttons down the page, each will run the same macro/do...
Excel tips : How to insert date in a cell ShowExcel tips : How to insert date in a cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press CTRL ¯+ ;¯ in the chosen cell. To insert current time, press CTRL¯+...
Delete duplicates in an Excel column ShowDelete duplicates in an Excel column To remove duplicates in an Excel column: Click on the Data menu Filter Advanced Filter In this menu, select the column where the duplicates Check the box "Extract without duplication"...
Download XLS (Excel) to DBF Converter ShowDescription The application is designed by WhiteTown Software. XLS (Excel) to DBF Converter is a tool that enables you to convert your XLS files to DBF format quickly and easily. Simple and easy to use, the application has been awarded from various...
Download Ms Word Excel Cracker ShowMs Word Excel Craker allows recover lost or forgotten passwords for .xls and .doc reated with Microsoft Office 97, 2000, 2003, XP or other word and excel compatible programs. This application will be necessary in case you should have received an...