ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Deactivate individual listbox lines (https://www.excelbanter.com/excel-programming/388572-deactivate-individual-listbox-lines.html)

ZipCurs

Deactivate individual listbox lines
 
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.

JLGWhiz

Deactivate individual listbox lines
 
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.


NickHK

Deactivate individual listbox lines
 
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.





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

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