Imagine a spreadsheet or array or ??? with a row of labels / codes at the top, and a row of labels / codes at the left. I populate this (right now, it's a listbox that has it's rowsource set with a dynamic query constructed in VBA), and the user selects a row / column by clicking.
Many of the row/columns are blank/null, so can't be selected. Whatever is selected, I want to return the two values from the row/col header labels. Sounds simple enough, but it's not apparent to me. Listbox's have no "column clicked" param...that I've seen. This is in ACC 2000.
Thanks for your insight,
Rich
Many of the row/columns are blank/null, so can't be selected. Whatever is selected, I want to return the two values from the row/col header labels. Sounds simple enough, but it's not apparent to me. Listbox's have no "column clicked" param...that I've seen. This is in ACC 2000.
Thanks for your insight,
Rich