listbox issue

**walid66** · 05-20-2008, 06:30 PM

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

Sub ListBox1_Change()
Dim lItem As Long
    For lItem = 0 To ListBox1.ListCount - 1
        If UserForm1.MultiPage1.Pages(0).ListBox1.Selected(lItem) = True Then
            ThisWorkbook.Worksheets("Processing_Data").Range("a65536").End(xlUp)(2, 1) = ListBox1.List(lItem)
            ListBox1.Selected(lItem) = False
        End If
    Next
End Sub

**mikerickson** · 05-20-2008, 08:10 PM

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.

**walid66** · 05-20-2008, 08:41 PM

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

**mikerickson** · 05-21-2008, 03:11 AM

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.

listbox issue

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

listbox issue

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions