Excel ComboBox Results to another cell?

Hello Everyone:

I am trying to get a selected option from an Active X Control ComboBox to appear in another cell.

If you select answer “A(or B,C,D…)” in the combobox in sheet one, how can I get the “A(or B,C,D…)” to appear in cell C3 in sheet2?

Any Ideas?

Thanks

Art W.

Is this a combobox from a userform in excel?
Where is the code for that control, in this Excel-File, in a module,....

Within the change-event of that combobox something like

Code:

---

Thisworkbook.Sheets(YourSheetIndex).Cells(3,3).Value=YourComboBox.List(Yourcombobox.ListIndex)

---