Attached file is unreadable. Please try again.

Try this one

here it is as a zip

unable to assist. File is locked as read only and cannot change on my side. Macro will not run as it is blocked by security on your end. Sorry. Good Luck.

How big is your monitor? Your userform is over 6k pixels wide, which makes it extremely hard to use!

@Velouria Ok i have to add code to stop it from resizing don't know why it dose it sometime? i been going into vba and resize it back to original size.

The userform is not resizing the userform settings are set to this size.
It's very bad coding and the error, well that's another issue.
O yes, and which version of Excel are you using?

It sounds (and looks) to me as though there may be some corruption in your workbook. I'd suggest rebuilding it.

When you look at the form size it's set to huge width and height.
Question of redesigning the userform and if needed use the zoom function.
Nothing to do with corrupted workbook for as far as I can see.
The OP has not informed us of the Office version he's using

Look at the controls on the form - do any of them look right to you? They all look distorted and they appear much bigger than their properties suggest they should be. For example, cmbShop is a combobox that is 150 pixels wide but it barely fits on my 1920x1080 monitor!

I honestly don't knwo what you have done but the size of the values in the Userform is out of bounds.
Furthermore the code is, if I may say so, very unprofesiionally built without any real 'intelligence built into it.
I made some adjustments to the form so that it's readable and visible like it should, but the code behind the buttons , well ...

Hope you can work witth this version and I suggest you lookup some code snippets and ideas on-line to make it user friendly.
Sorry for the 'bites' but as a VBA coder it hurts to see code like this