Cellvalidating not firing
Range("Equip Type") Then Target Range Value = Target.
Value A breakpoint is not even hit in this event when the data validation cell is changed and the breakpoint is on the Set ws Data = ...
NET, but, not to fear, there are several easy work-arounds that will get the trick done.
I'm not sure how to handle the scenario so I tried using the Row Validating event for the Product ID to allow for the Button Selection. Example: I have both a "Company" column and a "Division" Column.I'm assuming it should fire every time I tab away from a cell in the grid.At the moment I'm simply trying to present a message box but the event never fires. Thanks This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, Power Point, Outlook, and Access.I am manually handling the Datasource Update which is dependant on the validations. Let me diverge from the intial description to the REAL Issue.The idea revolves around a product ID column of an order detail line in a datagridview.
Search for cellvalidating not firing:
Otherwise, a valid company and division would pass the first line of validations and allow the Update of an Invalid Company/Division combination.