Hi All,

I have one combo box which contains the names of all the worksheets
within a workbook and one combo box which I would like to contain the
header row values for a particular worksheet which has been selected
from the first combo box.
I would like to know how I might go about making the second combo box
populate with the selected worksheet column header values just by
highlighting a particular worksheet in the first combo box and without
having to use a command button to complete the function.

i.e.

cboSelWksht
-------------------
worksheet1
worksheet2
worksheet3
-------------------

Highlight Worksheet1 populates combo box cboSelColumn with first values
for each column

cboSelColumn
--------------------
first Val A1
first Val B2
first Val C3
--------------------
etc.


Thanks very much for any help you provide.
--Brett--