VBA Auto Generate Next Number

Dear Friends

i am trying to generate auto next number, but could not find solution

the code is

Please Login or Register  to view this content.

your help would be greatly appreciated

Thanks in advance
Sagar

Maybe:

Please Login or Register  to view this content.

Regards, TMS

Hey Bro,

I have tried but no result, please help

Please Login or Register  to view this content.

Please post a sample workbook with typical data, buttons, code, etc.

Thanks, TMS

Sample Workbook attached

Try adding this routine to the form code:

Please Login or Register  to view this content.

Regards, TMS

Superb Awesome Perfect

Working perfect, what i wanted

Thank you so much

Reputation added

Regards
Sagar

You're very welcome. Thanks for the rep.