Odd behaviour - running program without clicking on code

tiredofit

Well-known Member
Joined
Apr 11, 2013
Messages
1,918
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
I have recently come across a program whereby if I merely hover the mouse over a particular line of code, the program runs.

Has anyone come across such odd behaviour?
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Yes. If you turn off the 'Auto data tips' setting, you shouldn't see the behaviour anymore.
I turned off auto data tip and, indeed, it stopped displaying the msgbox. In other words, nothing happened. Very good! Learnt something today. Thanks.

When you said " the code for that property has to be run to show you the value ", is the following code run when the mouse is hovering over the word IfToManyGoes? I'm asking because I put break points at the If statement and the following line and they did nothing. The code didn't break

VBA Code:
Public Property Get IfTooManyGoes() As Boolean
  
If LetterGuessed = "" Then StartGuess

IfTooManyGoes = (LetterGuessed <> "")

End Property
 
Upvote 0
Rory will correct me if I'm wrong - but that is probably because you're already executing code in Break mode, hence additional break clauses don't take effect. Once you'd returned a letter the code would run correctly and then the break clause on the If statement would work as expected.

Does that help?
 
  • Like
Reactions: yky
Upvote 0

Forum statistics

Threads
1,223,645
Messages
6,173,529
Members
452,520
Latest member
Pingaware

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top