thanks bob - yeah it worked, also, once ive for example typed the first
few letters it will then display the match, i then want to be able to
press the TAB button so it moves to the next cell, is that possible?
Also, if i was to type letters/words that didn't appear in the drop
down, can i get it to say something like 'not in list'??


--
stapleton2308
------------------------------------------------------------------------
stapleton2308's Profile: http://www.excelforum.com/member.php...o&userid=30878
View this thread: http://www.excelforum.com/showthread...hreadid=505670