LinkBack URL
About LinkBacks
I have a useform that I use to add data in sheet. What I would like to do is add an autonumber in my userform.
In attachments is my UserFrom
Please Edit and fix My code.
Thank You
I have a useform that I use to add data in sheet. What I would like to do is add an autonumber in my userform.
In attachments is my UserFrom
Please Edit and fix My code.
Thank You
Last edited by johan12; 10-09-2011 at 10:35 PM.
You could add this line to the userform intialize event
Nr.Text = CStr(Application.Max(Sheet1.Columns(1)) + 1)
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Originally Posted by mikerickson
You could add this line to the userform intialize eventNr.Text = CStr(Application.Max(Sheet1.Columns(1)) + 1)
Thank you very much for the help - Works Excellent . THANKS again
Last edited by johan12; 10-09-2011 at 10:32 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks