Hi,
I have a loop which goes through every sheet. From every sheet it will get values from a range and adds them in to a ComboBox. Now my problem is that because it goes through every sheet there might be same values. Values are like 2002/Jan, 2002/Feb, 2002/Mar and so on.
For example. In sheet1 could be only values from 2002/Jan to 2002/Dec. In Sheet2 could be values from 2002/Jan to 2003/Dec. In sheet3 could be values from 2003/Jan to 2004/Dec.
Is there a way how macro can neglet those values which already locate in the ComboBox??
Any help appreciated.
I have a loop which goes through every sheet. From every sheet it will get values from a range and adds them in to a ComboBox. Now my problem is that because it goes through every sheet there might be same values. Values are like 2002/Jan, 2002/Feb, 2002/Mar and so on.
For example. In sheet1 could be only values from 2002/Jan to 2002/Dec. In Sheet2 could be values from 2002/Jan to 2003/Dec. In sheet3 could be values from 2003/Jan to 2004/Dec.
Is there a way how macro can neglet those values which already locate in the ComboBox??
Any help appreciated.