I have a userform, wherein there are one combobox with two items i.e. Add Files and Add Folder. I want to add selected files or folder in listbox after doing following:
1. If I enter add files the browse files window open then I select file(s) and click OK, then combobox state should at its initialize state
2. If I click on downarrow then both items show
a) If I click on Add files then browse files window open
b) If I click on Add folder then browse folder window open
I have no knowledge of VBA. I need this combo like the Command Button as shown while we click DATA Tab, Connections Group, Connections Button then a userform opens. There is a button with two options Add and Add to the Data Model. How can I configure Add Files and Add Folder Combobox same as Add and Add to the Data Model Button. I am enclosing herewith Image of Excel window along with sample of userform in an Excel File. Kindly help me.