PDA

View Full Version : Functions only running during a breakpoint



xSmityx
10-27-2016, 08:59 AM
So I've created about 50 different templates that have been working just fine for over 2 years. Now for whatever reason some of the most basic functions aren't being executed. When I put a breakpoint in to see what was going on, it worked just fine. Now I will note that office just said I needed to update, so I clicked update and now this. Examples of the code are as follows:

Dim lbl As control
For Each lbl In Me.Controls

If TypeName(lbl) = "Label" Then
lbl.BackColor = RGB(253, 208, 23)

End If
Next

Even something as simple as making a control visible based off of a particular action, the control isn't becoming visible. I'm just wondering if anyone else has experienced this or if anyone has any troubleshooting ideas I could run through.

SamT
10-27-2016, 12:23 PM
Start with the basics

For Each lbl In Me.Controls

msgBox "Ctrl Name is : " & lbl.Name & vbcrlf _
& "ctrl Type: " & typename(lbl)

Next

gmaxey
10-30-2016, 10:29 AM
Office version? Could be caused or related to this issue:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_winother/known-issue-with-vba-forms-in-september-feature/ceb5161a-2b36-470c-a30d-b088bc131411?tm=1477513988651