I need to allow a user to select a consecutive range of columns, and then I need to programmatically access all the cells in the selected columns. Any help would be appreciated.
i.e. If a user clicks on Col 3 and then on Col 6, I need columns 3, 4, 5, and 6 to become highlighted. I then need to be able to populate all the cells in this range with certain values.
I have discovered that the 'LabelClickAction' property will go some way to helping me do this:
LabelClickAction="SelectField"
... but how do I programmatically select a column or range of columns?... and how to I iterate through those cells in code (VB)?
HI,
I am attaching a sample project that allows you to select a range of collmns by holding down the mouse left button over a group of fields. I have button click event that traverses the data in these columns.
Sincerely,
Matt DSE