How to implement Customer ID auto increment when using alpha numeric values with VBA

I have created a simple UserForm to enter new customer details to the Customer List in the spreadsheet, form works fine except for one little thing, which is New Customer ID, which works, but only with numeric values like 1, 2, 3 and so on.

Basically what I need this for to do is once form is opened/called new customer ID need to be created, which could be and Alfa numerical set of characters like AA-01234, AA-01235, AA-01236 and so on.

Also, is there a way of posting newly added Customer ID in the MsgBox along with MsgBox "One record added to Customers List. New Customer ID is "

All of my attempts to create this are failing and causing errors, which I really cannot figure out since I am new to VBA and had never used it until now.

Please help me a little.

Here is my code, Customer ID is TextBox1.

Thanks in advance

Please Login or Register  to view this content.

If my spreadsheet is required, please let me know and I can post it here

@AlphaFrog, thanks for your suggestion about "Unload Me", it is always good to learn something new.

The firs part part of the code did not work at all, possible reason is that I might have done something that I should not have.

If it is not too much can you please post entire code as it should be?

Thanks in advance.

I've posted code that I was trying at that point of time by accident. Here I am posting another version of the code and Image of the Customer DB where Data posted via UserForm is stored.

Please Login or Register  to view this content.

No matter how many times I try to enter a new customer details ID remains the same when realistically it should change every time, I cannot figure out what I am doing wrong. Please help and thanks for being patient

I have done so but it did not work, I ended with and Error

Try

Please Login or Register  to view this content.

Sweet, works like magic, but little too slow, otherwise perfect

Thanks a lot and once again thank for being patient!!

Originally Posted by Alexb77

Sweet, works like magic, but little too slow, otherwise perfect

Are you talking about the code I posted?

I have tested the code for myself with 47000 rows of data and took only 0.109375 sec.

It must be other part of your code....