Forum Discussion
Cant get enter and exit functions to work properly
I see that too, intermittently. Sometimes, the txtREQUESTERName_Enter event doesn't occur when it should. You can probably mitigate it by adding _MouseDown event procedures, such as you already have for cmbUPDATETYPE:
Private Sub txtREQUESTERName_MouseDown(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
txtREQUESTERName.BackColor = RGB(206, 234, 235)
End Sub
Do the same for all such controls.
- HansVogelaarApr 02, 2024MVP
- guitar713Apr 02, 2024Brass ContributorDO YOU HAVE ANY IDEAS TO GET THE COMBOBOX TO WORK WITH WHAT I WOULD LIKE TO DO?
- guitar713Mar 31, 2024Brass ContributorI really want to highlight the active controls. This makes a really nice form. In my head, we are dealing with one of the most popular software platforms out there, with these bugs, I can see why we don't use Microsoft to control rollercoasters and safety equipment. I'ld really like to find a solution for a good product for my company.
- HansVogelaarMar 31, 2024MVP
This is really buggy - the MouseDown event apparently cancels the Change event.
Using the keyboard to select an item still works.
Is it really worth all this trouble to highlight the active control?
- guitar713Mar 31, 2024Brass Contributor
take a look at my changes,, now we have another issue,, I have the Urgency box as a dropdown, not only does it not populate, but nothing happens. the same with the Update Type,,, what do we do now? Thanks.
- HansVogelaarMar 31, 2024MVP
As far as I can tell, it is a bug in the way userforms raise events for controls in frames. The problem is mentioned in other forums.
- guitar713Mar 31, 2024Brass ContributorMy bigger question is "WHY" does this happen. I thought these commands are supoosed to work in VBA, and are simple. Aren't we complicating the code by adding more code just to fix what looks like a "code" issue? any thoughts. Thanks.