Retrieving Data of certain cell

[larry711]

Hello.

I am trying to get the data out of a cell and put it in a textbox in my userform.
What I have is a Worksheet that has autofilter on. After the user clicks certain objectbuttons, there is only one row, that has data in it, displayed. The cell I'm after will always be in column A and be the second visible row.
Is this even possible?
Thanks

[shg]

Maybe

Please Login or Register  to view this content.

[larry711]

Well so far all I have been able to get is the value of cell A2. I'll keep playing and reading.
Thanks.

[larry711]

How would you go about getting the detail number from column A?
I'm thinking I need to rethink how I have Excel looking for the information I want. I just don't know which way to run. Well besides to books and asking people.

[shg]

Hmm. Try

Please Login or Register  to view this content.

[larry711]

That did the trick.
THANK YOU VERY MUCH!!!!!!!!!!!!