put info from a drop down box into another sheet

i have created drop down boxes that i now wish to retrieve data from and put
on another sheet?

try this macro
Private Sub ComboBox1_Change()
Sheet2.Range("A10").Value = ComboBox1.Value
End Sub

replace the fields /values as reuqired
where combobox1 is the drop down box name
sheet2.range("A10") is the another worksheet where you want the value


"kenny" wrote:

> i have created drop down boxes that i now wish to retrieve data from and put
> on another sheet?
>