I am a new member and a beginner at VBA coding and building UserForms. I would like to ask for some help from fellow members if possible please.
I have created a data entry userform. On this form is a textbox which I would like a unique new entry id to be generated each time I open and use the userform to enter new data.
For example, a unique id for the new entry would be: AAFL0001. The next entry would be: AAFL0002, and so on.
'AAFL' would be constant and '0001' would be sequential.
When I complete all the fields in my userform and add the entry to my spreadsheet then the unique id would also be added.
I would like to kindly ask for some guidance with the VBA coding for this please