Transfer Data in Userform

Hello i experiance some struggeling with this point.

The main point is transfer data from 1 variable outside the userform, inside the userform.


This is what i currently have wich wasn't so succesfull:

Please Login or Register  to view this content.

Userform:

Please Login or Register  to view this content.

In the first code is the code outside the userform. the values there are putten in M and WS correctly, but when the userform is opened it does not excist within the userform.

Is there another way by declaring the variables outside the userform and still be able to use them inside the "Private Sub UserForm_Initialize()"?

These two line

Please Login or Register  to view this content.

should be in a normal module, not a worksheet code module. If they are in a worksheet, you need to specify the code name of the worksheet when using them in the form - for example

Please Login or Register  to view this content.