combobox

[Harold]

Is there a way to indirectly pass the name of a table to
the listfillrange variable in the properties dialog box.

I am trying to find a value in one of several tables. The
spread sheet is set up with multiple searches into
multiple tables. Based on the fisrt selection (a
material), a table name is returned and saved in a cell.
Then a second search is made based on a part size, looking
in the proper table based on the material selection.
If the cell address for the table name is entered into the
listfillrange field in the properties box the string in
that cell is returned, or the entry is not accecpted in
the listfillrange field. In any case the name of the table
is not passed to the variable. I have tried entering the
cell address as; B7 "B7", 'B7', =B7, ="B7" and ='B7" Is
the proplem a syntax error, or is it not possible to use
indirect addressing to the table?