|
Not logged in [Login - Register] |
You Are Not Registered Or Not Logged In |
Corsa Sport » Message Board » Off Day » Geek Day » Any MS Excel experts » Post Reply
|
blebo |
posted on 4th Jun 04 at 14:19 |
In VB | |
Chris Bingham |
posted on 4th Jun 04 at 13:28 |
quote: Have a column which has all the 1's and 0's and then do a sum to add the totals. | |
Steve |
posted on 4th Jun 04 at 13:10 |
sorry i am using tick boxs, they are called check boxs in excel | |
Steve |
posted on 4th Jun 04 at 13:09 |
ok iv got it to flick a cell (H30) from 0 to 1 when i check or uncheck a box, now i have another check box and i want it to add or subtract to the figure in H30 when i check or uncheck the box? | |
HeNdie |
posted on 4th Jun 04 at 13:08 |
instead of a checking box, have a tick box, when the tick box is clicked instead of checked, it does the macro, of what u want to happen, ie a box loses a number or somet. | |
Steve |
posted on 4th Jun 04 at 13:07 |
im trying to a macro but cant do it, im not sure of the commands | |
Chris Bingham |
posted on 4th Jun 04 at 13:05 |
quote: A macro to do what? Put in rubbish answers on posts? ;) | |
Chris Bingham |
posted on 4th Jun 04 at 13:05 |
You will need an IF statement for each of the outputs so that it turns the output from TRUE to 1. | |
HeNdie |
posted on 4th Jun 04 at 13:01 |
do a macro. | |
Steve |
posted on 4th Jun 04 at 12:57 |
wher do i put this if statement? | |
Chris Bingham |
posted on 4th Jun 04 at 12:54 |
Ok, this is how I just did it. | |
Steve |
posted on 4th Jun 04 at 12:40 |
Im trying to do a VBScript in Excel that updates a Cell in Excel when an ActiveX Checkbox is checked, i.e. if its ticked say for instance cell B7 increases its number by 1 |