3 combobox.values to one cell
 

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

*** Sent via Developersdex http://www.developersdex.com ***

3 combobox.values to one cell
 

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" wrote in message
...


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

*** Sent via Developersdex http://www.developersdex.com ***

3 combobox.values to one cell
 

You are a genius Rick!
Works perfekt
Thank you.

*** Sent via Developersdex http://www.developersdex.com ***