I want to make sure that I have the correct formula for this situation. Here it is......I have about 60 combo boxes with amounts of lines ranging from 3 to 10, and I have all of the boxes linked to certain certain cells within the worksheet. I want the option that I pick to actually show up on a different sheet exactly how I see it in the combo box. What would be the best way to formulate this. Thank you for your help.