![]() |
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. |
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. |
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