This may be a stupid question for you gurus, but I need to
fill in a combo box from a column in another worksheet in
another workbook.

For example, I am designing a userform to allow the user
to scroll through a list of states, they can click on a
state and hit the Ok button.
I'm using a combobox and a command button, if this is not
the best design please feel free to let me know as this is
my first time doing this.

Thanks