control toolbox combo box
 

I am trying to input a control toolbox- combo box into a Excel worksheet. I
have a list of employees on a separate worksheet in the same workbook.

I have tried to get the sample at
http://www.contextures.com/xlDataVal11.html to work, Typing the code
exactly, but I must be missing something. I am able to get the combo box to
work if the list is on the same page, but not on the separate worksheet.

Any idea what I might be missing?