Hey everyone,
i am currently working on a project where i have to create a userform with multiple options to select from. These options include Option Buttons and ComboBoxes. Based on the selection in the userform by the user, the code should look for the item which matches the selected criteria and paste the related information(which will be in different cells) into another worksheet.
I have created a useform but i am not sure how to code the options buttons and the comboboxes in one sub so that they item that meets the criteria selected and will be able to paste the required information related to the found item to be pasted in another worksheet.
I need to use If Else or loops and how do connect so many commands.
Please help!
Thanks
i am currently working on a project where i have to create a userform with multiple options to select from. These options include Option Buttons and ComboBoxes. Based on the selection in the userform by the user, the code should look for the item which matches the selected criteria and paste the related information(which will be in different cells) into another worksheet.
I have created a useform but i am not sure how to code the options buttons and the comboboxes in one sub so that they item that meets the criteria selected and will be able to paste the required information related to the found item to be pasted in another worksheet.
I need to use If Else or loops and how do connect so many commands.
Please help!
Thanks
