View Single Post
 
Old 07-31-2022, 03:02 AM
tico22 tico22 is offline Windows 10 Office 2016
Novice
 
Join Date: Jul 2022
Posts: 3
tico22 is on a distinguished road
Default Different event trigger not working?

Great information here, thx a lot, especially @marcopod for sharing the examples.
I have one follow-up question: My goal is to have the coloring/change already displayed when the user selects a different option in the drop-down
=> trying to avoid the requirement to exit the control field

I here had some good first success using BeforeStoreUpdate instead of OnExit.

However, I seem to be out of luck with your example. My attempt:

Code:
'this works, but exiting is required
Private Sub Document_ContentControlOnExit(ByVal ContentControl As ContentControl, Cancel As Boolean)

' this would not require exiting, but does not seem to be triggered
Private Sub Document_ContentControlBeforeStoreUpdate(ByVal ContentControl As ContentControl, Content As String)
Any ideas why the event Document_ContentControlBeforeStoreUpdate is not triggered?
Attached Files
File Type: docm Content Controls - Dropdown Conditional Format.docm (28.5 KB, 5 views)