VBA Line to Send Userform Info to Parent Userform Textbox

Hello excelforumkeys,

All code in a UserForm is only available to the UserForm. Even if you have declared Selections as Public at the top of the UserForm.

By placing a variable in a standard VBA Module and declaring it Public, it becomes available to all code in your VBA Project. So by declaring Selections in a VBA Module, you can access it from any UserForm or anywhere in your VBA code.

Example

  '  At the top of the VBA Module
    Public Selections As String