VBA to return Listbox selected item row count.

[pedie]

Hi is there a way for VBA to return Listbox selected item row count.

I tried few ways like the ones below but wont work...
Please advice..

[/FONT]
[FONT=Courier New]Option Explicit[/FONT]
[FONT=Courier New]Private Sub ListBox1_Click()
 MsgBox Me.ListBox1.Item.Count[/FONT]
[FONT=Courier New] MsgBox Me.ListBox1.selectedrow.Count[/FONT]
[FONT=Courier New]End Sub

 

[meldoc]

Hi Pedie

Try.

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> ListBox1_Click()<br>  MsgBox ListBox1.ListIndex + 1<br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN></FONT>

 

[pedie]

Brian, exactly what I was wanting....Thanks alot!
I thought no one was answering this but didnt want to bump it up so it finally paid...

Thanks again Brian!

Regards
Pedie

Hi Pedie

Try.

Private Sub ListBox1_Click()
MsgBox ListBox1.ListIndex + 1
End Sub