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=505731

Instead of a combo box can you do a Validation list?
First, in a column somewhere list all the possible answers you want to be
entered.
Then click on the cell where you want someone to enter data and do the
following:
Select Data from the menu, then Validation. Under Allo, click List.
Then for Source highlight your list of potential answers.
Click OK and now you have a drop down box that will allow entry of only the
acceptible options.

Hope this helps.

"stapleton2308" wrote:


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=505731