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

[mangotti]

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!

 

[mangotti]

Ah Yes! My apologies. I did not know it was dependent on 6 characters and was testing something else with a different character count. It works indeed. Cheers!

Did you try it? If the last six characters of your field are digits (like you showed in your original message), it will work.