Good Day,
I am trying to automate a task in a tracker where I have a defined date, when this date has passed I wish to create a macro that will add 1 month to the date then adding an amount to an outstanding balance. updating the defined date in the process.
I have attempted to do this using date add within an if else statement in code on worksheet initialised but Vb is not liking the way I write.
Could anyone offer me some ideas to the error of my ways.

Many Thanks
Steve
I am trying to automate a task in a tracker where I have a defined date, when this date has passed I wish to create a macro that will add 1 month to the date then adding an amount to an outstanding balance. updating the defined date in the process.
I have attempted to do this using date add within an if else statement in code on worksheet initialised but Vb is not liking the way I write.
Could anyone offer me some ideas to the error of my ways.

Many Thanks
Steve