on error loop

**manforeyes** · 01-10-2009, 12:21 PM

Hi all,

I have a search button that do a vlookup based on what option button is choosen. for a couple of weeks I have been trying to write a error handle but with no success. I want to write a few different handles but it doesn't work. here is my code. First handler I want to create is if not found please update the outlook list If not found again maybe a typo if not found choose another option than loop. I hope i explained this correctly..

Please Login or Register  to view this content.

**royUK** · 01-10-2009, 12:38 PM

Why don't you use the VBA .Find method?

**manforeyes** · 01-10-2009, 12:39 PM

how can you help ?

**royUK** · 01-10-2009, 12:52 PM

I'm not sure what you are doing.

**manforeyes** · 01-10-2009, 12:55 PM

o.k I inport info from my work info so I can lookup easier and put it on a certain worksheet now based on that work sheet it will perform a vlookup based on what I select

**royUK** · 01-10-2009, 01:13 PM

Checking for errors with .Find is much easier, something like this

Please Login or Register  to view this content.

**manforeyes** · 01-10-2009, 01:16 PM

I have three criteria what do you mean do something else

**manforeyes** · 01-10-2009, 01:23 PM

what is LookIn:=xlValues)

**royUK** · 01-10-2009, 01:28 PM

take a look at the VBA helpfiles for .Find

Do something else means exactly that, add code for whatver you want to do if the search is unsuccessful

**manforeyes** · 01-10-2009, 01:31 PM

cool like if nothing found go to 2 right ?

**royUK** · 01-10-2009, 02:08 PM

Somethin like that

**manforeyes** · 01-12-2009, 08:45 AM

Hi again I tried the find however doesn't seem to work this is my latest attempt at error handler

Please Login or Register  to view this content.

**manforeyes** · 01-12-2009, 10:05 AM

what I am trying to do is prevent a run-time error to happenif the vlookup doesn't find what the user is searching for

**royUK** · 01-12-2009, 10:17 AM

Did you try replacing all the VLOOKUPS with.Find?

**manforeyes** · 01-12-2009, 10:17 AM

yes but no luck

**manforeyes** · 01-12-2009, 10:24 AM

how would I return the value from the next row example someone searches for Pete Peterson than there alais will appear and so will there extension ?

**royUK** · 01-12-2009, 10:31 AM

Please Login or Register  to view this content.

You probably need to attach the workbook.

**manforeyes** · 01-12-2009, 10:32 AM

I just retried it not sure how to get the value in the next row like a vlookup

**manforeyes** · 01-12-2009, 10:36 AM

tried this sort of working what I want is the value next to it not bekow it

**manforeyes** · 01-12-2009, 10:38 AM

cool starting to work better I did this

Please Login or Register  to view this content.

on error loop

LinkBack

Thread Tools

Rate This Thread

Display

on error loop

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions