ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   combobox rows format (https://www.excelbanter.com/excel-programming/423658-combobox-rows-format.html)

bert

combobox rows format
 
I want some way to indicate that a particular item in a ComboBox has been
"used"--that is, data related to the item exists in a spreadsheet. I'm not
sure the best way to do this (not the data-checking part, but the
displaying-the-result part). One way would be to make the used items appear
as bold text, if that's possible. My alternative, I suppose would be to
create another column and add a character ("" for example) when the related
row's item is used.
If there's a better way, I'm open to suggestions. Thanks.
Bert


JLGWhiz

combobox rows format
 
You can incorporate the code to display a flag into the same code that is
activated by the selection of an item in a combo box. That is assuming that
such code exists.

"Bert" wrote:

I want some way to indicate that a particular item in a ComboBox has been
"used"--that is, data related to the item exists in a spreadsheet. I'm not
sure the best way to do this (not the data-checking part, but the
displaying-the-result part). One way would be to make the used items appear
as bold text, if that's possible. My alternative, I suppose would be to
create another column and add a character ("" for example) when the related
row's item is used.
If there's a better way, I'm open to suggestions. Thanks.
Bert




All times are GMT +1. The time now is 08:10 PM.

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