Find a value in a column in the entire workbook and ad it into a Textbox

[RinorM]

Hi,

I have a UserForm that looks like the picture below:

Attachment 367271

What I am looking for to do is to find the largest value+1 in Column A2 in all Sheets in the Entire Workbook. For example if the value in A2 in sheet "Energi" is "0001" I want the "Löpnummer" in the userform to show "0002"

I know I should write something like this in the Userform-code:

Please Login or Register  to view this content.

Appreciate the help,

Regards,

[alansidman]

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.