Thread: For Each / Next
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
NicB.[_7_] NicB.[_7_] is offline
external usenet poster
 
Posts: 1
Default For Each / Next


Thank you, Tom. The combo-boxes are controls, not forms. Your code
worked very well, with the exception of one minor detail. The code
checks all sheets in the workbook, what if I needed it to only
reference one sheet? Is there a way to specify the worksheet? I will
try to solve this, but if you have the answer, I would greatly
appreciate it.

Thanks again for your help!

NicB.


--
NicB.
------------------------------------------------------------------------
NicB.'s Profile: http://www.excelforum.com/member.php...o&userid=20639
View this thread: http://www.excelforum.com/showthread...hreadid=544297