Re: the control object...
Why don't you set the tag to the Index of the control when it's checked, and set it to the NEGATIVE Index of the control when it's not.
That way, you could use the click event to multiply by -1, and then call your routine.
Pass the contol number to the routine, so that you start looping there.
Re: the control object...
you mean... instead of checking to see if the control value is true, just check to see if it's negative?
- that way i can work around the control object not supporting the value property.
i like the idea, and i'll try it out a bit later
please tell me if this is what you mean
Re: the control object...
btw when I add debug.print statements,
It cant even print to the immediate window because it has a runtime error when executing the debug.print statement.
There is a problem accessing the SeriesCollection 6 and 7 values and names.
Re: the control object...
Quote:
Originally Posted by mchow2469
btw when I add debug.print statements,
It cant even print to the immediate window because it has a runtime error when executing the debug.print statement.
There is a problem accessing the SeriesCollection 6 and 7 values and names.
huh??? please explain