Can VBA Match?
 

Hi,

If i had an input box where whatever the user put in would be equal to
a string, lets call that string d, would it be possible to write some
code which said match string d to the names which are in the range of
D1:ED1 baring in mind that in the range D1:ED1 is a list of staff names
so it should be possible to match string d to one of those names.

Could anyone provide code?


--
alymcmorland
------------------------------------------------------------------------
alymcmorland's Profile: http://www.excelforum.com/member.php...o&userid=27652
View this thread: http://www.excelforum.com/showthread...hreadid=482825

Can VBA Match?
 

option explicit
sub testme
dim res as variant
dim myRng as range
dim d as string

set myrng = worksheets("Sheet1").range("d1:Ed1")

d = inputbox(Prompt:="type something")

if trim(d) = "" then
exit sub 'user didn't type anything.
end if

res = application.match(d,myrng,0)

if iserror(res) then
msgbox "Not a match. The board goes back
else
msgbox "Found a match!
end if

end sub


alymcmorland wrote:

Hi,

If i had an input box where whatever the user put in would be equal to
a string, lets call that string d, would it be possible to write some
code which said match string d to the names which are in the range of
D1:ED1 baring in mind that in the range D1:ED1 is a list of staff names
so it should be possible to match string d to one of those names.

Could anyone provide code?

--
alymcmorland
------------------------------------------------------------------------
alymcmorland's Profile: http://www.excelforum.com/member.php...o&userid=27652
View this thread: http://www.excelforum.com/showthread...hreadid=482825

--

Dave Peterson