Searching and displaying data via VBA code

[kets23]

Hi

Would like a code that helps me identify a search criteria and takes me to the entered name or tells me that the entered name does not exist.

I have a command box on sheet 1 which will have the stored code, when this button is pressed, it brings up a user entry input box for the name to be entered, the name entered is then searched for within sheet 2. Sheet 2 holds the data and the named field is stored in column F. If the entered name exists, it takes me to that row, if it does not exist, than a message advising name not listed is displayed with ok button.

Column F has the full name so I would like the option to only enter part of a name i.e. surname within the user entry input box.

Alternatively, is there is a non vba of doing this by using excel's formula etc.

Many thanks

Kets

 

[SteveO59L]

how would you differentiate between similar names i.e Roberts or Robertson?

 

[kets23]

It would search for the surname entered i.e. if Roberts is typed in, it would search for Roberts only, hope this helps.

 

[SteveO59L]

Hi



Column F has the full name so I would like the option to only enter part of a name i.e. surname within the user entry input box.



Kets

so, you don't mean this?

 

[kets23]

Hi Steve

Column F has the full name i.e Joe Bloggs, search to be Bloggs or bloggs (but ignores case). If it makes it easier, can enter full name which I think would be better as it will then find the right person i.e. if there was a Joe Bloggs and a Tony Bloggs, probably best to use the full name so it finds the correct match.

Hope this makes sense.