RE How can you get row and col of listview not the text when detail mode TIA

RE How can you get row and col of listview not the text when detail mode TIA

Post by CobraStrik » Sun, 15 Aug 2004 06:54:45

Sorry I didn't made it clear.

I have a listbox in detail mode.
say I had 5 columns with 10 rows
how can I tell with row,col has been clicked on.

1. Change color of row (Col A thru Col Q) based on text value in Col J

2. Rows & Cols - copy formulas in Col A to # rows in Col B

I need to insert formulas in Col A along side unknown # rows of data in Col B
but can't seem to get the coding correct.
ie: Col B has continuous data in B3:B45 ; how do I enter a formula in A3
and using Range(Selection, Selection.End(xlToRight)).Select and/or
Range(Selection, Selection.End(xlDown)).Select
get the highlighted range to show A3:A45?
Using Range(Selection, Selection.Offset(0,-1)).Select give me 3 Cols
Also what about when Col B doesn't have contiuous data in the rows? How do
I determine and highlight the appropriate number of rows in Col A?


3. Which table design is better - more cols/less rows or less cols/more rows?

4. 200 COL Excel file with 700 rows -how to switch COLS & ROWS in ACC

5. Which table design more is correct - more cols/less rows or less cols/more rows?

6. Find date duplicates Col 2 or Col 3 then combine Col 1 text

7. find text from 1 col in 2nd col & return value from 3rd col

8. Text Combining Col A and Col B to Col A

9. Compare Col A and Col M, if Match, Copy Col N to Col E

10. ListView.GetNextItem return error if there only one row in listview and only one row selected.

11. Increase rows by 1 when moving data from col. to col.

12. How insert a row into table with IDENTITY col with defined value for that col

13. Master-detail: why doesn't detail DS automatically track row of master (i.e. :param not updated)?

14. How can I create a table w/ 5 cols. & 2/rows, then sort col 5 to