i have created drop down boxes that i now wish to retrieve data from and put on another sheet?
K kenny Apr 6, 2006 #1 i have created drop down boxes that i now wish to retrieve data from and put on another sheet?
F flow23 Apr 6, 2006 #2 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
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
