Filling a combo box from another workbook
-----Original Message-----
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
.
Use VBA and the Add Item method to populate the combo
box. Then you can get the information from a different
place.
Thanks,
Greg
|