Breakpoint not working Excel v.x

[Charles]

After installing Excel v.x. in my IBook with OS10. I created a program
to test. Ran the program with the breakpoint set and it didn't stop at
the breakpoint. Any suggestion as to the Cause?

 

[J.E. McGimpsey]

After installing Excel v.x. in my IBook with OS10. I created a program
to test. Ran the program with the breakpoint set and it didn't stop at
the breakpoint. Any suggestion as to the Cause?

Are you sure the code hit the breakpoint?

Without seeing your code, it's hard to even speculate otherwise...

 

[Charles]

Are you sure the code hit the breakpoint?

Without seeing your code, it's hard to even speculate otherwise...

Yes, I stepped it through, and I also wrote a code for a msgbox and
stepped it through. It to failed to stop. I also removed and
re-installed Excel. Still have the same problem.

 

[J.E. McGimpsey]

Yes, I stepped it through, and I also wrote a code for a msgbox and
stepped it through. It to failed to stop. I also removed and
re-installed Excel. Still have the same problem.

And did the message box get displayed?

In two years of daily debugging in XLv.X, I haven't seen this, so
I'm at a bit of a disadvantage.

Do you have selections, or does your code depend on which sheet is
active? That might create a difference between when you step through
it and when it runs on its own (i.e., if you're starting out with a
different sheet/range active).

Have you tried other breakpoints?

Removing and reinstalling XL is a Windows-type solution that is
rarely effective with MacXL. To do it right, you have to run the
Remove Office application that comes in the Value Pack folder of the
installation CD. The reload, reapply all the updaters, and repair
permissions. Did you do that? More effective might be to
remove/trash Preferenced from the ~:Libraryreferences:Microsoft
folder, specifically the Excel Settings (10) file and perhaps the
Microsoft Office Settings (10) and the Office Registration Cache X
files.

If it's something you can send me, I'd be willing to take a look at
it on my machine. Stuff it and attach it to an email from the
address you posted from. Document where it's not breaking.

If not, perhaps post the code and let us know where it's not
stopping.

 

[Charles]

And did the message box get displayed?

In two years of daily debugging in XLv.X, I haven't seen this, so
I'm at a bit of a disadvantage.

Do you have selections, or does your code depend on which sheet is
active? That might create a difference between when you step through
it and when it runs on its own (i.e., if you're starting out with a
different sheet/range active).

Have you tried other breakpoints?

Removing and reinstalling XL is a Windows-type solution that is
rarely effective with MacXL. To do it right, you have to run the
Remove Office application that comes in the Value Pack folder of the
installation CD. The reload, reapply all the updaters, and repair
permissions. Did you do that? More effective might be to
remove/trash Preferenced from the ~:Libraryreferences:Microsoft
folder, specifically the Excel Settings (10) file and perhaps the
Microsoft Office Settings (10) and the Office Registration Cache X
files.

If it's something you can send me, I'd be willing to take a look at
it on my machine. Stuff it and attach it to an email from the
address you posted from. Document where it's not breaking.

If not, perhaps post the code and let us know where it's not
stopping.

A follow up I tested a similar code in the Module form and it worked.
However it appears I should have told you I was testing a userform
code.
This is the simple code I used.

Private Sub CommandButton1_Click()
Dim msg1 as String()
msg1 = "This is a Test" breakpoint here
msgbox msg1
end sub

On the PC side it worked
Mac sid it didn't

 

[J.E. McGimpsey]

A follow up I tested a similar code in the Module form and it worked.
However it appears I should have told you I was testing a userform
code.
This is the simple code I used.

Private Sub CommandButton1_Click()
Dim msg1 as String()
msg1 = "This is a Test" breakpoint here
msgbox msg1
end sub

On the PC side it worked
Mac sid it didn't

I'm not sure what's going on.

Your Dim syntax will give an error in VBA5. However, when I used

Private Sub CommandButton1_Click()
Dim msg1 As String
msg1 = "This is a Test" ' breakpoint here
MsgBox msg1
End Sub

on a userform with one command button, and clicked on the button,
the code stopped at the breakpoint, the VBE opened, and the
breakpoint line was highlighted.

You could try deleting Excel and Office preferences, but I don't
think that will help.

If you'd like me to take a look at the original file, send it to me
from that address either stuffed or zipped.

 

[Charles]

I'm not sure what's going on.

Your Dim syntax will give an error in VBA5. However, when I used

Private Sub CommandButton1_Click()
Dim msg1 As String
msg1 = "This is a Test" ' breakpoint here
MsgBox msg1
End Sub

on a userform with one command button, and clicked on the button,
the code stopped at the breakpoint, the VBE opened, and the
breakpoint line was highlighted.

You could try deleting Excel and Office preferences, but I don't
think that will help.

If you'd like me to take a look at the original file, send it to me
from that address either stuffed or zipped.

I think my breakpoint issue is solved. I down loaded an update from
Microsoft which now allows me to set my breakpoint. The version is
Office X 10.1.2. Thanks for your help on this issue. Now on to another
breakpoint issue. After setting the breakpoint I run my program it
stops at the breakpoint however the userform stays on top, but I can
also see the vb code behind it. I have to move the form around or I
can click the " - " button on the form to move it to the dock ??. Is
this way it should work? On the PC side the form is hidden.

 

[J.E. McGimpsey]

I think my breakpoint issue is solved. I down loaded an update from
Microsoft which now allows me to set my breakpoint. The version is
Office X 10.1.2. Thanks for your help on this issue. Now on to another
breakpoint issue. After setting the breakpoint I run my program it
stops at the breakpoint however the userform stays on top, but I can
also see the vb code behind it. I have to move the form around or I
can click the " - " button on the form to move it to the dock ??. Is
this way it should work? On the PC side the form is hidden.

Don't know about "should", but it's the way it does work, probably
since it's a modal dialog - they work somewhat differently for Macs
and PCs under the hood. I've always considered it a minor
inconvenience.

BTW- I encourage you to download and install updates 10.1.4 and
10.1.5 as well. There is a perceptable speed increase, as well as
some stability issues (though I never had much problem with 10.1.2).