Assuming a combobox from the control toolbox toolbar.

for i = 0 to Activesheet.combobox1.Listcount - 1
Combobox1.ListIndex = i
Activesheet.Printout
Next


--
Regards,
Tom Ogilvy


"bigwilly11189"
wrote in message
news:bigwilly11189.1wfxyf_1128535542.1367@excelfor um-nospam.com...

Hi,

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


--
bigwilly11189
------------------------------------------------------------------------
bigwilly11189's Profile:
http://www.excelforum.com/member.php...o&userid=21527
View this thread: http://www.excelforum.com/showthread...hreadid=473488