Step Into (F8) causes faded blue-grey screen with gears

[Prof Wonmug]

The following 6-line function is in my private add-in module:

1 '*********************************************
2 Function test(a, b)
3
4 test = a + b
5
6 End Function

I set a breakpoint on line 4. In a worksheet, I put "=test(A1,A2)".
When the function executes, it stops on line 4. If I press F8 (step
into), the entire screen turns a light blue-grey with two gears in the
middle. The blue-grey screen is about 50% opaque so that I can see the
IDE and other windows behind the gears. If I press F8 again, it goes
back to the IDE but does not execute any code. Repeated presses of F8
toggles the blue-grey screen on and off.

What the heck is going on and how to I fix it?

 

[AltaEgo]

Lose line numbers 1 and 2 in you code:

'*********************************************
Function test(a, b)
3
4 test = a + b
5
6 End Function

If it isn't this, bets me!

 

[Prof Wonmug]

Lose line numbers 1 and 2 in you code:

'*********************************************
Function test(a, b)
3
4 test = a + b
5
6 End Function

If it isn't this, bets me!

The line numbers aren't in the actual code. I put them in the post for
reference. The function looks like this:

'*********************************************
Function test(a, b)

test = a + b

End Function

 

[Barb Reinhardt]

I think you need to dimension a and b within the function statement.

Function Test (a as variant, b as variant) 'or some other dimension

 

[Barb Reinhardt]

Try this

Function Test(a as range, b as range)

test = a.value2 + b.value2

end function

 

[Prof Wonmug]

I think you need to dimension a and b within the function statement.

Function Test (a as variant, b as variant) 'or some other dimension

Aren't call parameters dimensioned as Variant by default? Besides, the
function works correctly. It adds the two passed values and returns
the sum.

In any case, I tried your suggestion and also Integer, Short, Long,
etc. I still get the same result.

Has no one ever seen this before?

 

[Prof Wonmug]

Try this

Function Test(a as range, b as range)

test = a.value2 + b.value2

end function

Nope. F8 still toggles that odd blue-grey screen.

S-F8 and F5 work just fine. The function works fine if the breakpoint
is removed.

C'mon. Someone must have seen this odd behavior.

I am running Excel 2007 on Win XP.

 

[Prof Wonmug]

The following 6-line function is in my private add-in module:

1 '*********************************************
2 Function test(a, b)
3
4 test = a + b
5
6 End Function

I set a breakpoint on line 4. In a worksheet, I put "=test(A1,A2)".
When the function executes, it stops on line 4. If I press F8 (step
into), the entire screen turns a light blue-grey with two gears in the
middle. The blue-grey screen is about 50% opaque so that I can see the
IDE and other windows behind the gears. If I press F8 again, it goes
back to the IDE but does not execute any code. Repeated presses of F8
toggles the blue-grey screen on and off.

What the heck is going on and how to I fix it?

Problem solved. Accidentally, I happened to notice a little icon in my
system tray with those same two gears. Hovering over it displays the
message that it is Yahoo! Widgets. Right-clicking on it offers me the
option to exit the program. Problem solved.

For awhile there, I thought I was going nuts.

 

[AltaEgo]

Remind me never to install Yahoo Widgets