I created a macro called Update, and I assigned each combobox the macr
Update. So, now it will switch back and forth for you...

+-------------------------------------------------------------------
|Filename: CoOp Spreadsheet.zip
|Download: http://www.excelforum.com/attachment.php?postid=3987
+-------------------------------------------------------------------

--
dok11
-----------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...fo&userid=1058
View this thread: http://www.excelforum.com/showthread.php?threadid=48102