View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default 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