Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I have a list box on a user form that I have set up to have an outline appearance. High level items with lower level items listed below. I would like the higher level items to be inactive, (i.e. can't be selected). Can this be done? How? In the meantime, I plan to write some code that deselects the higher level code. Thanks in advance. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I don't believe the properties for a list box will support what you describe.
However, if you only have one lower level item per high level item, you could write your click event code so that the same action is performed if either are selected. If you have more than one low level item per high level, of course, there could be a problem. Outside of that, the other alternative is to delete the highlevel items from the list. "ZipCurs" wrote: Hello, I have a list box on a user form that I have set up to have an outline appearance. High level items with lower level items listed below. I would like the higher level items to be inactive, (i.e. can't be selected). Can this be done? How? In the meantime, I plan to write some code that deselects the higher level code. Thanks in advance. |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sounds like you are using the wrong control. Try a tree view maybe to
represent the structure. NickHK "ZipCurs" wrote in message ... Hello, I have a list box on a user form that I have set up to have an outline appearance. High level items with lower level items listed below. I would like the higher level items to be inactive, (i.e. can't be selected). Can this be done? How? In the meantime, I plan to write some code that deselects the higher level code. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to insert individual lines into a cell | Excel Worksheet Functions | |||
Calculate to total individual lines | Excel Discussion (Misc queries) | |||
Format Individual Grid Lines | Charts and Charting in Excel | |||
Combining lines from individual sheets into one summary sheet | Excel Programming | |||
How do I remove the individual subtotal lines from a pivot table.. | Excel Discussion (Misc queries) |