Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
3 combobox.values to one cell
You are a genius Rick! Works perfekt Thank you. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
combobox values | Excel Programming | |||
Two values in a combobox | Excel Programming | |||
Fill values into a listbox matching selected values from a combobox | Excel Programming | |||
ComboBox Values | Excel Programming | |||
ComboBox Values | Excel Programming |