Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Best Way to select multiple values on single click?

Status
Not open for further replies.

SetiRich

Technical User
Dec 10, 2001
5
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top