VBA code to generate Autonumber

[ActualReality]

Can you please help me with this issue as mentioned below:
I want to generate a complaint # in a way that today is 9th Oct 2012 then the complaint number should be 090812001...last 3 digits will keep on adding like 090812002, 090812003 and so on for that day only...But when the date changes the counter resets to 100812001, 100812002, 100812003 and so on for 10th Oct 2012...The user form should have a text box on which it should me displayed while submitted the form...Can you help

[Sa DQ]

hope this help for you

[Artik_PL]

Full code in UserForm module with controls TextBox1 and CommandButton1:

Please Login or Register  to view this content.

Artik