I have this code it works fine a shown below but when I change "Sub ListBox1_Change()" to "Sub ListBox1_Click()" it won't work. The output will be blank but if I change it to "Change" there is an output. Any ideas why that is?
Thanks
Please Login or Register to view this content.
From what I can see, a ListBox does not intiate a Click event when it is set to multi-select. From VB Help
"For some controls, the Click event occurs when the Value property changes. However, using the Change event is the preferred technique for detecting a new value for a property. The following are examples of actions that initiate the Click event due to assigning a new value to a control:
(snip)
"• Selecting a value for a ComboBox or ListBox so that it unquestionably matches an item in the control's drop-down list. ...
(snip)
"The Click event is not initiated when Value is set to Null."
However, when set to multi-select, ListBox1.Value is Null.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
OK I can use the change command instead of click but I have one problem when I use the change command. The problem is that when I click on a value the backcolor disappears. but if I use the click command and click on a value the backcolor comes back but the macro does not work. Is there a way to have the backcolor on on Change?
Thanks
I'm not sure what behaviour you are talking about.
I've noticed that a) the Click event preceeds the Change event.
2) in a non-multi-select ListBox, both the previous and new selections are highlighted during the Click event, but only the new selection is highlighted during the Change event.
You may want to look at the MouseDown or MouseUp events.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks