Dan,

If each cell (B8:B228) is entered individually the following code will show
UserFrom1 whenever a change in column B results in a No in column K.

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target.Cells, Range("B8:B228")) Is Nothing Then
If Target.Offset(0, 9).Value = "No" Then UserForm1.Show
End If
End Sub

If the cells (B8:B228) may be entered in groups then a modification will
need to be made - perhaps a For Loop - to accomplish the same. Let me know
if you need help with that.

Mike


"Dan N" wrote:

I have a shared file where people enter a number in column B8 through 228. In
column K8 through 228 are formulas that look at the numbers in column B and
deliver a "Yes" or a "No." I want Excel to show user-form1 whenever a formula
delivers a "No." When the user-form is displayed, the user will click the OK
button to close the user form and allow the next user to repeat the process.

I'm really spinning my wheels on this. Your help would be greatly appreciated!
Thanks in advance. - DN