This is a Userform LIstbox queston: A variable does not set to the value of a listbox
Hello forum and thank you for taking time to read this. I am completely stuck on what I think is a simple problem but I have invested several hours so far an cannot crack this one. Maybe one of you will be able to identify a fix. I have included an attachement that is a watered down verison of the big program and makes it fast and easy to see what I am stuck on.
In a nut shell, the statement
S11 = Uf_CertPlan_Owner.Lb_TeamPerformance
S11 is suppose to set to the value of a listbox but it remains blank. S11 is declared as a string and the value in the list box is "High" but after running this line of code the variable S11 remains blank. But S12 and S13, set in a similar manner do set correctly so why does S11 refuse to set to high?
Please open the excel workbook and double click any cell to launch the "menu of services" userform, then follow the process and you will be prompted to control-break and read some remarks in the code that will show you exactly where the variable is being set but if you hover your mouse over the variable you will see it is blank.
|