Pulling Numeric Values into Form's ComboBox without Blank cells

I’m trying to solve an issue in the code in the attached Excel 97 workbook (“TestCbo.xls”).

I have two sheets and a form with a combobox. On the first worksheet (“Intake”) there are three columns (H,I,& J)with blanks in some of the rows of these columns. I’m pulling the value in column “I” into column “A” in a second worksheet (“TagsTemp”) using “If”, “Or”, “And” and “Lookup” functions, which works. I then have a form (“UserForm1”) with a combobox (“combobox1”), which is populated from column “A” of “TagsTemp”. Only the cells with number values are supposed to be listed in ComboBox1 without any blanks between the number values populated. From there a number is selected from ComboBox1 and assigned to the relevant cell in column “J” of “Intake” sheet and the “values” in column “A” of “TagsTemp” worksheet are cleared as opposed to the If/Lookup formula and the process starts over again when ComboBox1 is activated with the assigned number now not available in ComboBox1 for subsequent selections. There appears to be an error in my coding below to remove the blanks from the list.

I would greatly appreciate some help with this issue.

Thanks much!

Please Login or Register  to view this content.

TestCbo.xls

Works perfectly JP.

Greatly appreciated.

Thanks so much!