Excel Fox
07-24-2011, 03:25 AM
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
Check the attachment for a sample