Setup a list of values,a nd set the ListFillRange property to those cells,
say M1:M10.

To set that property, go to design mode (click the blue-green triangle on
the control toolbox toolbar), and then double-click the combo. This takes
you to the VB IDE, make sure properties window is open (Ctrl-G), and set
that property. Exit design mode and go.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"stapleton2308"
wrote in message
news:stapleton2308.22agvy_1138357801.2656@excelfor um-nospam.com...

i cant seem to make that work, do i have to use VBA for it, if so what
do i need to do as i aint gotta clue!!!


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