ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Multiple Combo Box Indices? (https://www.excelbanter.com/excel-programming/358228-multiple-combo-box-indices.html)

ll

Multiple Combo Box Indices?
 
I am working with a combo box populated with a collection from a
spreadsheet which has some blank cells (intentional). I would like for
the combo box to not display the blank rows (which I've managed to get
it to do), and also for another index to count the total number of
rows. I can't use the index for the combo box, as it omits the blank
rows.
Is it possible to have two indexes (one for display and one for true
row counting)? I need to keep the position in the collection with the
row counting.

Many thanks,
Louis


Tom Ogilvy

Multiple Combo Box Indices?
 
Assuming a combobox from the control toolbox toolbar.
there is no built in support for it. You could put in two columns in the
list and maintain the true row there. You can hide that column using the
ColumnWidths setting.

--
Regards,
Tom Ogilvy



"ll" wrote:

I am working with a combo box populated with a collection from a
spreadsheet which has some blank cells (intentional). I would like for
the combo box to not display the blank rows (which I've managed to get
it to do), and also for another index to count the total number of
rows. I can't use the index for the combo box, as it omits the blank
rows.
Is it possible to have two indexes (one for display and one for true
row counting)? I need to keep the position in the collection with the
row counting.

Many thanks,
Louis



ll

Multiple Combo Box Indices?
 
Thanks Tom,
If the two columns were in the same listing, would the selection of the
visible column items generate the index, or could it be set so that the
visible items could reference the hidden column, which would generate
the index?

Thanks again,
Louis


Tom Ogilvy

Multiple Combo Box Indices?
 
you just read the value (row number) from the list and use it. There is no
generating.

--
Regards,
Tom Ogilvy

"ll" wrote in message
ups.com...
Thanks Tom,
If the two columns were in the same listing, would the selection of the
visible column items generate the index, or could it be set so that the
visible items could reference the hidden column, which would generate
the index?

Thanks again,
Louis





All times are GMT +1. The time now is 05:39 PM.

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