Hello,
I am new to VBA but for a project I would like to be able to show search results in the listbox on the form based on the user selection made in the userform which consiste of 3 combo boxes and 3 option boxes (see user form below) . The result should return a local country, name and email for a selected reviewer type and domain based on the selected values <450 < 1M etc. If not availabe or not athorised it should show the one that is available in different GEO. I have created the user form but I am stuck at the code for the search function. From the many online resources I looked at I am not sure if this is possible to do. I have included the screenshot to hopefully get some feedback and code suggestions. Thx
I am new to VBA but for a project I would like to be able to show search results in the listbox on the form based on the user selection made in the userform which consiste of 3 combo boxes and 3 option boxes (see user form below) . The result should return a local country, name and email for a selected reviewer type and domain based on the selected values <450 < 1M etc. If not availabe or not athorised it should show the one that is available in different GEO. I have created the user form but I am stuck at the code for the search function. From the many online resources I looked at I am not sure if this is possible to do. I have included the screenshot to hopefully get some feedback and code suggestions. Thx
