Excel 2007 ListObject question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ferris - 28 Aug 2007 02:13 GMT

I have a data table in xl2007 that is a ListObject. What I would like
to be able to do is know which ListRow has been selected. In other
words, if I manually select a cell in a ListObject is there a way to
programatically know which ListRow that is? Banging my head for a bit
trying to noodle it out, any help will be greatly appreciated.

Thanks!

Reply to this Message

Jim Rech - 28 Aug 2007 13:52 GMT

Maybe you want something like this:

Sub a()
Dim MyList As ListObject
Dim RowNum As Long
Set MyList = ActiveCell.ListObject
RowNum = ActiveCell.Row - MyList.HeaderRowRange.Row
MsgBox RowNum
End Sub

Signature

Jim

|I have a data table in xl2007 that is a ListObject. What I would like
| to be able to do is know which ListRow has been selected. In other
[quoted text clipped - 3 lines]
|
| Thanks!

Reply to this Message

Ferris - 28 Aug 2007 17:36 GMT

Yep, that does work out nicely. Thanks!

> Maybe you want something like this:
>
[quoted text clipped - 14 lines]
> |
> | Thanks!

Reply to this Message