ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Comboboxes (https://www.excelbanter.com/excel-programming/275548-comboboxes.html)

David W[_3_]

Comboboxes
 
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



Dick Kusleika

Comboboxes
 
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






All times are GMT +1. The time now is 12:36 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com