Thread
:
If no FIND value is found, then a Msgbox to say so and exit sub
View Single Post
#
2
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
If no FIND value is found, then a Msgbox to say so and exit sub
Howard,
Try,
Dim FoundCell As Range
Set FoundCell = Selection.Find(....)
If FoundCell Is Nothing Then
MsgBox "Not Found"
Else
MsgBox "Found"
End If
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com
"L. Howard Kittle" wrote in message
news:Q90cb.555341$YN5.373629@sccrnsc01...
Hello Excel users and experts,
Win XP, Excel 2002
A number is scanned into cell A1 and the below code is called through a
change event macro. It finds that value in range aList and a date stamp
is
entered 2 columns to the right of the find value. This works fine.
However, if there is NOT a value found in aList, then for some reason the
date stamp is entered in first row of aList, 2 columns over. What would
be
the code to prompt a message box "Not Valid No." when there is no find? I
can't figure out how to "catch" the fact that a number was not found.
Sub BookReturnDate()
Dim aList As Range
Dim Bcode As Variant
Bcode = Range("A1").Value
If Bcode = "" Then Exit Sub
Set aList = Range("G2:G2505")
On Error Resume Next
aList.Select
Selection.Find(What:=Bcode).Activate
ActiveCell.Offset(0, 2).Value = Now
'If no find then msgbox "Goof Up"
End Sub
Thanks for your help,
Regards,
Howard
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson