how to generate serial number on a textbox in userform

Hi,

Good day,

I have an excel vba userform program, i was able to generate a serial number but it doesnt work well. When i click add new button the serial number is not populating. And when i open the userform again same serial number is generating so im having a duplicate serial number.

Is there any way to fix this?

Here's my code:

Please Login or Register  to view this content.

Thanks in advance,

Hello minionrush,

Welcome to the Forum!

You have disabled the TextBox. Once a control is disabled it will no longer respond to input from either the keyboard or mouse.

If you want to prevent the user from altering the TextBox contents then set the Locked to True. The user can not change the TextBox but you can through code.

Please Login or Register  to view this content.