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

bump.......


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

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