Thanks,

What my intention is, is to require the user to use the next row. Data is
placed on the worksheet by the UserForm "Lost_And_Found" I just want to
make sure that when the UserForm only shows if the row above has data. So if
the select C10 (to use your example) then there must be data in cell E9.


"Mike H" wrote in message
...
and if the actiice cell (target) was (say) C10 where is rng(1,5) in
relation
to that?

"Patrick C. Simonds" wrote:

I meant say that I want it to check the rng(1, 5) of the row above.


"Patrick C. Simonds" wrote in message
...
Is there a way to have this check the rng(1, 5) for a value.

If the value is blank I need to fire a msgbox "Sorry but you have
clicked
to far down on the worksheet. Please select the next blank row."

If the value is not blank then show the UserForm.



Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)

If bSELCTIONCHANGE Then

If Not Application.Intersect(Target, Range("B3:M5000")) Is Nothing
Then
Lost_And_Found.Show


End If

End Sub