View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Naz Naz is offline
external usenet poster
 
Posts: 85
Default Display "Does not exist" upon search no results

On error go to ErrorHandler


ErrorHandler:
Msgbox "error message"




--

_______________________
Naz,
London


"Jean-Jerome Doucet via OfficeKB.com" wrote:

Hi,

I'd like my search looping in VBA to display a message that says that the
identification written does not exist in the list. It must be something like
"On Error GoTo MsgBox" To I imagine. But I don't know hw to write it.
Thx

JJD

--
Message posted via http://www.officekb.com