template wizard wont let me select a form control (combo box) value to
associate a field with but provides a reference cell value which gives me the
row number in the other workbook of the value. how do i make a valid cell
reference from this reference? i.e. col of referenced value is "A", row is
variable depending on what value i pick in combo box. how do i make a
reference out of "A" plus the value to equal "A5" ? (so that i can associate
a field with it using the template wizard)
--
bob z