help with auto number on userform

Hi,

after days and days of research i have hit a stumbling block with my code and i hope you can spare a minute to help me.

i have a workbook with two worksheets, Documents and Workings. The user can fill in the userform i have created so that it fills in the worksheet in documents accordingly.

My code is as folows:

Please Login or Register  to view this content.

What i am trying to achieve is auto numbering in column B in Documents with D1, D2, etc.

Each time the userform is opened or restarted or populated by a the command button it populates the D1, D2 etc textbox on the userform and then the form submits the alll the data to the next free row in the worksheet.

As you will see i have with my very limited knowledge created a work round utilising the workings worksheet to populate column L and then transfers this to the userform. This code relys on the cell above A2 to be a number.

Is it possible to dispense with my workround and get the userform to populate the textbox automatically as it reads from column B in the documents worksheet, collects the last D number used and allocates the next one, if the form is blank then it should allocate D1 in the first instance.

I do hope i have made some sense and that this last hurdle can be overcome, thank you in anticipation,

regards

Lee

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

You missed the / from the last code tag. Edited for you