"INDIRECT" References in Userform ComboBox--Excel 2003
Does anyone know a way to use the "=INDIRECT" function in a userform combobox the same way it would be used in a regular combobox (i.e. one that is just in a spreadsheet)? In other words, I have two comboboxes with lists of choices. In the first box, the user will select a region, and based on that selection, the second box will show a list of cities in that region. I know how to do this in a regular combobox, but I'm not sure how to do it in a userform.