Help: Macro Button to update "Month"

[wakefield101]

Hi all,

I was wondering if I could receive help creating the following macro button. What I envision is a button that each time I click on it, it will automatically update my "Month" cell (cell D7) to the next month.

For example, if my "Month" cell is currently showing Jan-2016, then once I click on this button, Jan-2016 will update to Feb-2016.

Does anyone know how to code this?

 

[Joe4]

Is the entry in D7 formatted as Date or Text?
An easy way to tell is to see if this formula returns TRUE or FALSE
=ISNUMBER(D7)

Once we know if it is a Date or Text, we will know how to best approach it.

 

[wakefield101]

Yes, the Date is formatted with the code Date format, mmm-yy;@

 

[Joe4]

OK. This macro would do that:

Sub AddMonth()
    Range("D7") = DateAdd("m", 1, Range("D7"))
End Sub

 

[wakefield101]

Thanks! Mr. Excel MVP!!

I might have a follow up question for you, I just need to play around with it first..