Hi I Was Wondering if i was able to get a more indepth example

Currently when I set up comboBox's i Insert Values by using "Add Item"
eg With UserFrom.cboxLocation
.AddItem "A"
End With
However This is only suitable when the list is small
I Need to be Able to fill a combobox with hundreds of values.
I want to set my Form up so that i can click a button and in doing so
places values into the combobox.
The values which need to go into the combobox are located in seperate
worksheet.
ie Roads Starting with "A" are located in column A of the worksheet

Any Input would be much Appreciated