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

-----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

A combobox and a command button sound fine for picking a state.

--
Regards,
Tom Ogilvy

John wrote in 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

Thanks for the feedback Tom, now can you tell me how to
get the list of states into the combo box?

Thanks.
-----Original Message-----
A combobox and a command button sound fine for picking a
state.

--
Regards,
Tom Ogilvy

John wrote in
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


.

If you have them on a worksheet, go into the vbe and get the properties
window for the combobox. go to the rowsource property and put in text like

Sheet1!A1:A50

this should load the combobox with your state names when the form is shown.

--
Regards,
Tom Ogilvy

"John" wrote in message
...
Thanks for the feedback Tom, now can you tell me how to
get the list of states into the combo box?

Thanks.
-----Original Message-----
A combobox and a command button sound fine for picking a
state.

--
Regards,
Tom Ogilvy

John wrote in
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


.