I apologize about the cross post. It shows I am a newbie . I tried placing this code into both the combobox1 code and the code for worksheet "TR-Metric Pg2" and both did not work. Is there something I am doing incorrectly? The range the combo box is gathering data from is BJ11;BJ100 in another worksheet called "CTC-Form". I apologize if I am missing something obvious, but I am just now trying to learn this stuff.

thanks,