Hi all,
Everytime I am adding new data, I wanted the ID textbox to display a new unique ID for the new record automatically. I wanted it to continue even if I close the file. The code has been created but it's not works 🙁
Note : The textbox of idNum was disabled as user not allowed to key in manually.
I would like to ask for your help on this please. See attached below for your review. Thanks in advance.
Hi Mariya
You can refer attached for an example.
I am finding the maximum value in column A and then add 1 to it.
This will give the next sequence number.
Hope this helps.
Sunny
Hi Sunny,
It is works. Thanks for your help !
By the way, I have question, how to adding a format ie A0001, A0002, .. in the existing code ?
Hi Mariya
I will use a different method for this. I am assuming you want a physical prefix with leading zeroes and not formatting the cell.
Refer attached.
Sunny
Hi Sunny,
It's works ! Thanks 🙂 🙂
