ExcelBanter - listbox-combobox category

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - listbox-combobox category (https://www.excelbanter.com/excel-programming/276857-listbox-combobox-category.html)

GUS

listbox-combobox category

is it possible to have in a combobox or listbox categories that cannot be
selected.
example
combobox list must appear as :

names
gus
jim
jhon
david
fruits
banana
orange
games
Tetris
tennis
basket

user can only select the values (jim,john,orange, tennis etc)not categories
(names,fruits,games)
Is this possible.

Tom Ogilvy

listbox-combobox category

Not by using a setting.

You could design your code to unselect them.

--
Regards,
Tom Ogilvy

"GUS" wrote in message
...
is it possible to have in a combobox or listbox categories that cannot be
selected.
example
combobox list must appear as :

names
gus
jim
jhon
david
fruits
banana
orange
games
Tetris
tennis
basket

user can only select the values (jim,john,orange, tennis etc)not
categories
(names,fruits,games)
Is this possible.

All times are GMT +1. The time now is 07:53 PM.