Solved: Combobox Value in Userform to a textbox in an activeworksheet

[jammer6_9]

Hello,

How can i save a combobox value from a user form to a textbox place in a worksheet.

[VBA] Private Sub cmdSave_Click()
Sheets("training!txtTrainer1").Value = cmbTrainer2.Value

End Sub[/VBA]

Error message is;

Run Time error (9)
Subscript is out of range

Thank you in advance for any help out.

[feathers212]

This worked for me:
[vba]Private Sub cmdSave_Click()
Sheets("training").txtTrainer1.Text = cmbTrainer2.Value
End Sub[/vba]

[jammer6_9]

huhhh it was an easy code but without the expert like you how will i know... A big dump of thankssss...

[lucas]

Hi jammer,
If your thread is solved please mark it as solved using the thread tools at the top of the page....