i have an command button array of 42 buttons. every once in a while in the click event i get this 'expression too complex' error. the line of code is

ElseIf Int(cmdDay(Index).Caption) < 15 Then

i am using an error handling add in. the add in picks up the error and kicks out of the sub. now if i set my options to break on all errors it will break on that line and then i can continue with out changing anything. it is almost as if the machine doesnt feel like doing that line of code at that moment. i know that is not possible but i have no other explanation.

also on every 8 clicks of the array i get the error 'invalid procedure call or argument' on the line

myMonth = Format(inString, "mmmm")

instring is passed into the routine as a valid date string and mymonth is a local variable declared as a string.

any ideas why i get these random errors.