3 combobox.values to one cell

[Axel]

Is it possible to get the value from three comboboxes in to one cell
Combobox1 Combobox2 Combobox3
1 1/16 HWDP
2 1/8 DC
3 3/16
4 1/4
5 5/16
6 3/8
7 7/16
8 1/2
9 9/16
10 5/8
11 11/16
12 3/4
13/16
7/8
15/16
I wonder if it's possible to write a code who can take the selected
values from the 3 comboboxes (with for example a commandbutton), and
paste the values i to one cell.
Or if it any other way to do i
Gratfull for all help!

Axel

 

[Rick Rothstein \(MVP - VB\)]

Something like this maybe...

Private Sub CommandButton1_Click()
Range("A1").Value = ComboBox1.Text & "-" & _
ComboBox2.Text & " " & _
ComboBox3.Text
End Sub

where you choose the cell you want filled in.

Rick

 

[Axel]

You are a genius Rick!
Works perfekt
Thank you.