View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default If ListBox = "" then

I don't understand.

Do you want the message if you don't find anything or if you do find something?

You may be able to just look at the .listcount of that listbox:

if me.listbox1.listcount = 0 then
.additem "your string here"
end if



Eddie_SP wrote:

I gave the code to OssiecMac...

If you use "Notify me of replies", this is just for you to receive the
message.

Thank you Dave, as always... =)


--

Dave Peterson