Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match 2 Columns, Return 3rd, Differing Match Types | Excel Worksheet Functions | |||
Lookup Formula: Return 1st match, then 2nd match, then 3rd match | Excel Discussion (Misc queries) | |||
index(match) Wind Uplift Calculations (match four conditions) | Excel Worksheet Functions | |||
MATCH Multiple Criteria & Return Previous / Penultimate Match | Excel Worksheet Functions | |||
Lookup? Match? pulling rows from one spreadsheet to match a text f | Excel Worksheet Functions |