This video shows how to use Kode Magd to generate the VBA that populates a Listbox or Combobox on a form, from a verity of different sources of data.
- Single value.
- An array of different values.
- Named Range on an Excel Sheet.
- A Range on an Excel sheet that is defined by hardcoded address.
Note: A drop down list on the sheet is different. This is related to the data validation of a cell.