Combobox values to a work sheet crashing Excel

[daseffects]

I've been using the code below w/ some success to write the values of comboboxes to worksheets on change. However, my userform just started crashing Excel everytime I combobox was selected. Removing the code stopped the problem.

Is there a more efficient method of replicating the below?

Private Sub ComboBox5_Change()
Range("sheet1!a1&quot = Userform.combobox5.value
End Sub

I've also tried the below w/ no success

Private Sub ComboBox5_Change()
Range("sheet1!a1&quot.value = Userform.combobox5.value
End Sub

David

 

[unica]

Hi David,

Try this one:
Private Sub ComboBox5_Change()
Worksheets("Sheet1&quot.Range("A1&quot.Value = ComboBox5.Value
End Sub

Good luck.

Regards,
Unica