Adding a sort to userform code

Hi all I have a userform to add new records to a worksheet. It works fine, but assigns a reference number based on that of the previous record. If the worksheet isn't sorted correctly it gives an incorrect reference number.
I thought this would be simple however whenever I come to add new code to this routine I receive errors in the already written and working parts of the code( Type Mismatch). I can only imagine this means that although the routine works, it does have errors in the way its written.


Can someone please tell me what I have missed?

Please Login or Register  to view this content.

Thank you

Hi, excelloser,

maybe WorksheetFunction.Max will deliver the correct result if itīs numbers (you can add 1 to that for the next number). BTW: your code should be worked over thoroughly - I personally dislike Forms that let me do all the work and check at the very end when all has been filled out.

Ciao,
Holger