Unloading data from Userform to Sheet

[daseffects]

I've set up a combobox on a form using properties that set the Controlsource = Sheet1!A1 and the rowsource = Sheet1!B1:B10.

How do I get the Userform to update A1 on each change of the combobox and not just when the form closes as its currently doing?

Thanks

D

 

[Bowers74]

This should do the trick:

Private Sub ComboBox1_Change()
Sheet1.Range("A1").Text = ComboBox1.Value
End Sub

I hope this helps!



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!

 

[daseffects]

Tried it but I get run time error'424' object required error. Do I need to define an object before the code?

D

 

[daseffects]

Got it to work w/ this slight tweek

Sheet1.Range("A1&quot = UserForm1.ComboBox1.Value


Thanks

 

[Bowers74]

Oooops,

Sorry about the ".Text" part, I must not have been thinking straight.



Peace!

Mike

Never say Never!!!
Nothing is impossible!!!