No -

by using Type:=1 in the InputBox method, he was restricting entries to
numbers.

Also by assigning the results to a Long variable, entering letters or an
alphanumeric combination would cause an error - the variable should be a
String variable.


In article ,
Joel wrote:

the code should work on a string only if the string in the text box exactly
matches the cell.