List Box Control problem

[SQUIDD]

Hello All

I think i may have backed myself into a bit of a corner, and before ripping apart and starting again i thought best to check.

How would i return the row number of the listbox i double clicked without running a for loop to check, thing is, i may have already checked some boxes as i work down the list.

thanks

Dave

 

[Artik]

Probably

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    MsgBox Me.ListBox1.ListIndex
End Sub

The list is numbered from 0.

Artik

 

[SQUIDD]

Probably

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    MsgBox Me.ListBox1.ListIndex
End Sub

The list is numbered from 0.

Artik

Thanks so much, perfect, worked great.

Dave

 

[Joe4]

SQUIDD,

Please Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.

 

[SQUIDD]

Hi Joe

Sorry about that, i must have clicked the wrong one in error.

Honest mistake.

Thanks for correcting.

Dave