If you find yourself wanting to pass values between one userform and another userform without having to store those values on the spreadsheet, the simplest method would be to use your defined variables based on the required data type, ensuring that they are public in scope.
Check the attachment for a sample
