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 ***

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" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
>
>
> 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 ***

You are a genius Rick!
Works perfekt
Thank you.

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