Combine 2 subs

**tday7** · 10-07-2011, 02:24 PM

Hello all,
Totally new to VBA.Found 2 subs that do what i need, but how do i combine them to work on same sheet? One sub will accumulate a cell by using 2 cells. The second sub automatically adds the date when ever i change the accumulating cell.

Example: I am using 4 columns A,B,C,D

Column A (Names)
Column B (Date)
Column C (Daily Entry)
Column D (Total)

C & D are the accumulating and when ever i change a cell in column C the cell in column D will accumulate and the cell in column B will update the date.
Make sense?

Here is first sub...

Please Login or Register  to view this content.

Here is second sub...

Please Login or Register  to view this content.

I really dont know much at all about subs, i just searched out and found these already made, but have no clue as how to combine them.

Any help is much appreciated.
Thanks,

Troy

**tigeravatar** · 10-07-2011, 02:36 PM

Troy,

Something like this?

Please Login or Register  to view this content.

**tday7** · 10-07-2011, 02:42 PM

WOW!! Not at all what i thought it would look like. No complaints thow

Thanks much

Works just like i need it.

Troy

**tday7** · 10-07-2011, 02:49 PM

I have another issue. After placing VB inside of sheet, i then try to save book and get the following window.

I know its sumthin simple

Any direction?

Thanks,
Troy

**tday7** · 10-07-2011, 02:54 PM

Duh. I figured it out. How dum of me.

Chose the .xls extension and all saves fine.

Troy

**Mordred** · 10-07-2011, 03:11 PM

You can also choose the .xlsm extension. Given that you are working with Office 2007, you should choose xlsm instead of .xls because .xls is the extension for Excel 2003.