Excel: Create a Macro with button to generate the next sequential number in an Alphanumeric string

I looking for some assistance in creating a macro that when a button is clicked, the macro sequentially increases an alphanumeric string, example of the string is as follows and the number should increase by 1 after the macro is run. CA-123456 When macro is run, next alphanumeric will be CA-123457 Thanks!

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of April 24, 2015.

For more resources for Microsoft Excel