UserForm to automatically display next number

Hello all,

I am struggling with an issue of having the UserForm display the next shop number automatically. In my worksheet(SOL) I want the shop number to automatically be filled starting with 1. The first entry should be in B8. After hitting "Save" command button the next sequential number should appear on the order form. Below is the code I tried to use to make this happen:

Please Login or Register  to view this content.

Thank you kindly for your assistance.

Best

Likayuu

I am getting an error on this line of code if this helps

Please Login or Register  to view this content.

If there is a different way other than using the string I used above I am open to any suggestions.