Andy Malan

[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

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1054532-how-do-i-copy-data-3-separate-combo-boxes-3-cells-excel.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread. (I've closed this older one since its title is not informative like the other one)