Mouse down event to select item in combo box not working correctly

I am using an ActiveX combo box on a worksheet. I am trying to select an item with a mouse. I have found the code below and it does work. However, unless you place the mouse pointer on the very bottom of the item highlighted in blue, it will select the item above it. Is there another way to do this? or is there a way to adjust the code to make this function better?

Private Sub TempCombo_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Single, ByVal y As Single)
  
   If TempCombo.TopIndex > -1 Then
        Dim curIndex As Integer
        curIndex = TempCombo.TopIndex + Application.WorksheetFunction.RoundDown(y / 13.5, 0)
        CurValue = TempCombo.list(curIndex)
   End If
  
End Sub

Open in new window

Microsoft ExcelMicrosoft Office

Last Comment

Mike French

8/22/2022 - Mon

Martin Liss

12/20/2019

This will select the next entry in the combobox.

Private Sub TempCombo_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal x As Single, ByVal y As Single)

    With TempCombo
        If .ListIndex > -1 Then
            .ListIndex = .ListIndex + Application.WorksheetFunction.RoundDown(y / 13.5, 0)
        End If
   End With
  
End Sub

Open in new window

Mike French

12/20/2019

ASKER

Well, I tried using your solution but I get no value whatsoever into my variable. See the code below. You essentially changed the "TopIndex" for "ListIndex". What am I missing here?

    If TempCombo.ListIndex > -1 Then
        Dim CurIndex As Integer
        CurIndex = TempCombo.ListIndex + Application.WorksheetFunction.RoundDown(y / 13.5, 0)
        CurValue = TempCombo.list(CurIndex)
    End If

Open in new window

Martin Liss

12/20/2019

That looks like your original code rather than what I posted in my previous post. Did you actually use my code?

Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!

Walt Forbes

ASKER CERTIFIED SOLUTION

Mike French

12/20/2019

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.