I am creating a userform in VB. In my form I have a combo box. I am trying to populate this with values from a different workbook in a different location. The range that it is referring to, also, may have blank cells which I would like ignored for the population of the combo box. Any pointers on how to do this would be extremely helpful.