Auto ticket generator

[Mr.Karr]

Hello

Can anyone please provide a code snippet or a demo file to generate ticket# automatically.

In detail: I have an activity to enter records via userform to the existing data dump. The requirement is to add a ticket# system (can be concatenated with date + counter) so we can mark them as unique and for future reference.

Please help.

Many thanks in advance.

 

[Hui]

Can you upload a sample file and explain what should happen and when

 

[Mr.Karr]

thanks hui for your response. I just figured it out and let you know if any help required.