I'm very new to Visual Studio (literally got hold of Visual Studio 2016 last week at work), so apologies if this is an easy answer....
I've created a simple Task pane Add in for Excel with a number of Checkboxes. The sheet contains a column with True/False on each row.
What i would like to do is to be able to Enable/Disable these Checkboxes using the Application.SheetSelectionChange Event when the user moves over each true or false row - say, if the active cell is A1 and the value for that cell is true, i would like the checkbox to be enabled; and if they move to A2 using the down arrow and the cell value is false, i want the checkbox to be disabled. However, i've no idea how to do this.
I put the Application.SheetSelectionChange Event into the ThisAddin.vb class module which allowed me to show the cell address in the status bar, but this is about as far as i have got.
Help would be much appreciated!
Thanks in Advance
Gerard
Aucun commentaire:
Enregistrer un commentaire