PC Review


Reply
Thread Tools Rate Thread

Deactivate individual listbox lines

 
 
=?Utf-8?B?WmlwQ3Vycw==?=
Guest
Posts: n/a
 
      2nd May 2007
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 With Quote
 
 
 
 
=?Utf-8?B?SkxHV2hpeg==?=
Guest
Posts: n/a
 
      2nd May 2007
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.

 
Reply With Quote
 
NickHK
Guest
Posts: n/a
 
      3rd May 2007
Sounds like you are using the wrong control. Try a tree view maybe to
represent the structure.

NickHK

"ZipCurs" <(E-Mail Removed)> wrote in message
news:7ACED03D-2603-4037-9F19-(E-Mail Removed)...
> 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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to insert individual lines into a cell Jonigirl Microsoft Excel Worksheet Functions 3 27th Mar 2009 11:27 AM
Calculate to total individual lines =?Utf-8?B?Q3VyaW91cw==?= Microsoft Excel Misc 2 18th Jul 2007 12:53 AM
Format Individual Grid Lines =?Utf-8?B?RkdN?= Microsoft Excel Charting 4 24th Mar 2007 01:40 AM
delete lines through individual letters =?Utf-8?B?cmFpbmUgNDc=?= Microsoft Word New Users 3 18th Dec 2006 12:12 AM
aninmate individual lines to come in one at a time =?Utf-8?B?aGNzb2JvYg==?= Microsoft Powerpoint 9 2nd Jul 2005 01:52 AM


Features
 

Advertising
 

Newsgroups
 


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