well, i do a lot of ASP, so i got very confused with VBA but basicly i
trying to get it so that the user enters in the ID number of a row tha
looks like this:

ID Firstname Lastname
1 John Smith
2 etc etc

so they would enter in "1" and "John" would appear as a result

i could do this with a for loop going down the whole id column(A) an
check against the variable that i have from the enteered ID i suppos
but there has to be a better way

This is my first piece of VBA but i know a little VB and a lot o
ASP(which is almost similar:p) so don't think im stupid just because
can't do this relatively simple piece of VB

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements