What do you want to happen to B1 if, after the list box is created, the
user changes the value in A1 to either 0 or 2? Remove the list box,
change the values or just leave it alone?


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=381897