Tom,

What is the problem with the code you used? What error did you
get? The ListIndex property will return the 0-based index of the
selected item, or -1 if no selection is made.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"TOM" wrote in message
...
Hello,

I have ListBox, there are few rows. I just need know which one
is select
(order number). I tried this: MsgBox ListBox1.ListIndex ... but
I quess this
is bad.

Can you help me.
Thanks
Tom