Try something like this...
txtMyTextbox.text = sheets("Sheet1").range("A65536").end(xlUp).value + 1
This assumes that you have numbers in column A. An error will be generated
otherwise.
--
HTH...
Jim Thomlinson
"clarefoxly" wrote:
Hi, I have a user form to add jobs to my worksheet, each job has a job
number which run in a list down the A column, the problem is you have
to type the new job number in manual in the text box on the userform for
ever new job..
Is the away to make it look down the list in column A for the last
one and then +1 onto it and auto load it into the job textbox on my
userform?
Thanks Clare
--
clarefoxly
------------------------------------------------------------------------
clarefoxly's Profile: http://www.excelforum.com/member.php...o&userid=24183
View this thread: http://www.excelforum.com/showthread...hreadid=384541