Code to provide unique number when macro button is clicked to open UserForm

Hi,

I have a spreadsheet with two UserForms.

One UserForm adds records.

One UserForm allows users to views/edit records - this is a dropdown based on each row having a Unique Reference number entered at the Add Record stage.

The code for the 'Add Record' UserForm is below, it all works fine and achieves its purpose.

The only way you can add to the spreadsheet is by hitting the Add Record button.

However, I want to create a function that automatically assigns a Unique number to the spreadsheet once the Add Record button is pressed even if, for example, someone goes in and manually deletes a line. The 'Unique Reference Number' is at the moment manually entered and falls under 'NameTextBox' in the code below.

Any help is greatly appreciated.

David

Please Login or Register  to view this content.

Do you have any code that I could use for this? and where to enter it?

I am very new to this, have bundled along until this point.

Many Thanks

David

try ..

Please Login or Register  to view this content.

and change NameTextBox.locked to True
or remove the NameTextBox completely and use ...

Please Login or Register  to view this content.

Hi,

thanks for this, I am very new to this, where abouts would I put this in my code?

Many Thanks

David

using your code it would be as follows (see highlighted lines) ....

Please Login or Register  to view this content.

Great Thanks!!!