Hi,

What I want to do is loop through a combobox that already contain
values and print the sheet each time a new value is selected. Fo
example if the list contains: Apples, Oranges, and Bananas and I clic
on a command button, it automatically selects apples, then prints, the
selects oranges, and prints, etc. until it reaches the last item in th
combobox. There are formulas that give a different output on th
worksheet each time a new item from the list is selected. Can this b
done? I dont' have any code to do this, so any help would b
appreciated.
Thanks

--
bigwilly1118
-----------------------------------------------------------------------
bigwilly11189's Profile: http://www.excelforum.com/member.php...fo&userid=2152
View this thread: http://www.excelforum.com/showthread.php?threadid=47348