Excel VBA Listbox use of SelectedIndexChanged event

excel vba listbox selectedindexchanged
Mike Wojcik picture Mike Wojcik · Apr 26, 2017 · Viewed 7.6k times · Source

I am trying to utilize the Excel VBA Listbox SelectedIndexChanged event to update a textbox on the same userform with the sum of the values in one column of my listbox as the user selects each row in that listbox.

I can not figure out how to get the code for that event handler to execute. Any suggestions? I am using Excel VBA with the latest version of excel from office 365 on a windows 10 machine. In fact i don't even see that event listed in the pulldown when i have the code window up for that userform?

Thanks Mike

Answer

shakespeare picture shakespeare · Apr 27, 2017 
Private Sub ListBox1_Change()
  // Your can do anything with it

  // Looping here
     For i = 0 To ListBox1.ListCount - 1
       If ListBox1.Selected(i) Then
        ListBox1.Selected(i) = False
       End If
     Next
  End Sub

Related questions

How to get selected value in multicolumn listbox

I have a multicolumn listbox in my userform and I would like to get all the values of the elements which are in the selected row in the listbox.Here is my userform: Just like in the photo, I want …

Read More
VBA Excel Populate ListBox with multiple columns

This may be a cheap question for some but I'm totally confused on how to populate my listbox. Using this line I can populate the listbox as shown below: ListBox1.List = Sheets("Sheet1").Cells(1, 1).CurrentRegion.Value or Dim rngName As …

Read More
Populate list box with a named range

I'm working on my first ever VBA project, and need a bit of absolute newbie guidance. I have a submission form that staff will be using to submit their daily KPIs. I have a list box control in a user …

Read More