06-11-2023 01:35 PM
Hi, I want to get a list of selected cells in a Multicolumn Listbox.
I'm using a Mouse Down event to select the desired cells. This works great.
Now, I need to read the Listbox, and get a list the selected cells. I tried reading the cell colors, but was unsuccessful.
Anyone know how to do this?
Solved! Go to Solution.
06-11-2023 02:16 PM
Hi,
On a MultiColumn ListBox, you cannot select individual cells. You can only select entire rows, whose indexes are given by the control value itself.
Here you are emulating selection of individual cells by coloring them in green, but they are not selected in the sense of the MultiColumn ListBox. So if you want to get their coordinates, the best way would be to keep track of every cell you are coloring in green in an array of coordinates (Row, Column):
Regards,
Raphaël.
06-11-2023 02:35 PM
Similarly, you can also read the background color.
06-11-2023 03:44 PM
That's it!
Thanks