Graeme Smith
New member
Hi, I am wanting to develop a bit of code for a userform that creates a unique ID for each new record added to the associated spread sheet. The unique ID would be made up of the first two characters of four or five columns. I tried to do this in the spreadsheet by concatenating and copying the formula down the column, however when a new record was added it was illustrated below the last cell of the formula, therefore I realised that it needs to be done as part of the coding for the userform.
I would greatly appreciate someones assistance in providing an example bit of code that I can utilise in the userform.
regards
Graeme
I would greatly appreciate someones assistance in providing an example bit of code that I can utilise in the userform.
regards
Graeme