mardi 17 janvier 2017

Enable/Disable Checkbox in Custom Task Pane Excel Add in with OnEvents

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