Alright go ahead a laugh now
Never have done one, but how do you set up a combobox that has an index and
a data source
I have got a "A13:172" as an index
and "F13:172" as a data source
how do you set it up so when the first box the user selects what index
number he wants, then the second box finds the data in that row, how do you
link the 2 boxes together
The index does not need to be changed but the data source does
I'm Learning
Thanks David

David

Is this what you are talking about?

http://www.contextures.com/xlDataVal02.html


--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"David W" wrote in message
...
Alright go ahead a laugh now
Never have done one, but how do you set up a combobox that has an index
and
a data source
I have got a "A13:172" as an index
and "F13:172" as a data source
how do you set it up so when the first box the user selects what index
number he wants, then the second box finds the data in that row, how do
you
link the 2 boxes together
The index does not need to be changed but the data source does
I'm Learning
Thanks David