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...
[VBA: VB6] Using excel from another application Show[VBA: VB6] Using excel from another application Here is a little routine to call Excel from VB6 or another Office application. Paste in a general module (eg Module1) In VBA>> Insert>> Module and paste in the window ... In VB6>>...
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¯+...
Ask your question Reply
They need your help