ComboBox "Drop-down list"

Here, you can,

Once you have created your ComboBox (also known as a drop-down list) in a UserForm,

Add items to the ComboBox from a worksheet; these items are displayed directly in the ComboBox (Watch the Video)

Add UNIQUE values to the ComboBox from a worksheet (Watch the Video)

Add items to the ComboBox using code (Watch the Video)

Create 3 dependent ComboBoxes in cascade. Values embedded in the code (Watch the Video)

Open internet Websites based on ComboBox values (Watch the Video)

Display in the ComboBox the names of the tabs of ALL Worksheets (Dynamic) (Watch the Video)

Sort ListBox columns according to the selected column in ComboBox (Watch the Video)

Based on selection in ComboBox, Fill TextBoxes (Watch the Video)

Intuitive Search – Start Typing to Search in ComboBox (Watch the Vidéo)

Simply insert the requested value in the box, click on the “Get code” button and Hop, the code appears in the square at the very bottom of the page… copy it and paste it into your UserForm…That’s it 🙂

 

---

Add items to the ComboBox from a worksheet:

---

Add UNIQUE values to the ComboBox from a Worksheet:

---

Add items to the ComboBox using Code:

---

Create 3 dependent ComboBoxes in cascade. Values embedded in the Code:

---

Open internet Websites based on ComboBox values:

---

Display in the ComboBox the names of the tabs of ALL Worksheets:

---

Sort ListBox columns according to the selected column in ComboBox:

---

Based on selection in ComboBox, Fill TextBoxes:

---

Intuitive Search – Start Typing to Search in ComboBox:

Copy the Code