I request your kind support for my below example related with Vba Query on Userform. I have the below attached example , where i have made a list ( which will increase accordingly in future) .
Currently the list name is called Category in List tab . This "Category" list , i have three items added which is server, storage and switch . As mentioned earlier, this list will be added more .
I have created a form, where i need to add multiselect list , so from left side, i have the full form and right side i only select one or two what is needed . Then i click next to go next tab.
Here i want to add the prices or discount on left side, based on the dropdown list which i have selected from the previous tab . So in my example , if i select Server and Storage, next tab , i need t find in pull down list menu and enter its corresponding values in the left side , which will get reflected in excel sheet .
is this possible in excel vba user form as my objective is to check , if i can add more lists in future or do i need to code manually for it .