I've just learned how to do combo box's - but what i want to be able to
do is once ive put in the 1st few letters (auto complete will then kick
in), once i've selected the one i want, i want to be able to press the
tab button so it will move onto the next cell, is this possible?????
Also, for example, if i was to enter info into the box which wasn't in
there, is it possible for a box to pop up to say 'not listed' or
something, rather than leaving the wrong info in there?

Help would be much appreciated


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

Hi Stapleton,

Try using a ComboBox from the Controls toolbox.

Set the combo's MatchEntry property to fmMatchEntryFirstLetter and set the
ListFillRange to the address of the list. Set The MatchRequied property to
True.


---
Regards,
Norman


"stapleton2308"
wrote in message
news:stapleton2308.22aujr_1138375513.8256@excelfor um-nospam.com...

I've just learned how to do combo box's - but what i want to be able to
do is once ive put in the 1st few letters (auto complete will then kick
in), once i've selected the one i want, i want to be able to press the
tab button so it will move onto the next cell, is this possible?????
Also, for example, if i was to enter info into the box which wasn't in
there, is it possible for a box to pop up to say 'not listed' or
something, rather than leaving the wrong info in there?

Help would be much appreciated


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