I have just started trying to master UserForms and I have ran into a problem. Using a button module from sheet1 to activate a ListBox object, the user can readily select their desired input from the Listbox just fine. However, I cannot seem to get the selected input passed back to worksheet module.
As an example, the variable the user is inputting from the UserForm is the string Employee # defined as strEmployeeNo. How do I get it back to a worksheet module?
I tried the following declaration in both the worksheet, workbook, and userform module, to no avail.
#Public strEmployeeNo as String
Thanks,
Larry Ezell