- Registration date
- Monday November 9, 2015
- Last seen
- December 6, 2015
Let's say we have in column A1 to A5
A1 = 1
A2 = 2
A3 = 3
A4 = 4
A5 = 5
- Right click your combobox and choose "Format Control".
- Click on the "Input Range" field.
- Click cell A1 and drag all the way to A5.
That's it. Click on the combobox and you have all the values in it.