How do I Copy the data from 3 separate combo boxes to 3 cells in Excel?

[andymalan]

How do I Copy the data from 3 separate combo boxes to 3 cells in Excel?

I have 3 combo boxes on a user form, comboBoxFrame, comboBoxPanel, comboBoxEdging.
comboBoxFrame is populated with a list of solid timber,

comboBoxPanel is populated with sheet material,

comboBoxEdging is populated with edging material.

I also have a command button to save the selections.

I want to make the selections from the 3 combo boxes, then click the “save selection” button and the selections are to be copied to sheet(“material”)
comboBoxFrame, to cell N2
comboBoxPanel, to cell O2
comboBoxEdging. to cell P2

The code I have cobbled together as follows, does not work.

Private Sub ComboBoxEdging_Change()
Sheets("Material").Select
Range("P2").Select
ActiveSheet.Paste
End Sub

Private Sub ComboBoxFrame_Change()
Sheets("Material").Select
Range("N2").Select
ActiveSheet.Paste
End Sub

Private Sub ComboBoxPanel_Change()
Sheets("Material").Select
Range("O2").Select
ActiveSheet.Paste
End Sub


Your expertise will be greatly appreciated by this greenhorn (me) who is totally new but keen to learn.
best regards, Andy Malan

 

[Fluff]

Try

Private Sub ComboBoxEdging_Change()
Sheets("Material").Range("P2").Value = Me.ComboBoxEdging.Value
End Sub