Hi Dear,
I have one book with userform to enter data. Textbox1 is used for ID for each form. This form add data to another book called Suppliers.
I want vba to automatically generate ID number in sequence for each set of data.
please help.
regards
Rahat
If you are entering these ID's in a column next to the one with the dates, then all you would need to do is if it is in Column A then just get the next value is MAX(Range("A:A")) + 1
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks