Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
GUS GUS is offline
external usenet poster
 
Posts: 45
Default 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.



  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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.





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A SUB CATEGORY USING DATA VALIDATION? ALRDY USNG DV FOR CATEGORY sameer Excel Discussion (Misc queries) 2 January 11th 10 12:55 PM
Combobox/Listbox Difference WLMPilot Excel Discussion (Misc queries) 1 November 21st 06 01:46 PM
listbox B conditional of input in Listbox A Kim K Excel Discussion (Misc queries) 1 October 31st 06 08:27 PM
Combobox v Listbox MBlake New Users to Excel 5 April 24th 05 11:58 AM
Combobox/listbox FSt1 Excel Discussion (Misc queries) 3 January 4th 05 06:55 PM


All times are GMT +1. The time now is 04:30 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"