Hi Alvin
I am not sure that I understand you ?
You can use kurtype.Value in your other code to use the value of the selected item in the combobox
--
Regards Ron de Bruin
http://www.rondebruin.nl
"alvin Kuiper" wrote in message ...
Hi
I use this to make the values in a combobox
Dim myrange1 As Range
Set myrange1 = Sheets("ark1").Range("navne")
For Each a In myrange1
kurtype.AddItem a.Text
Next
The range("navn") is a namerange there taking all the values in row 1
In my combo box i want to see the values i have this is what i also have
today
but when i choose one value in my combobox i want to get the columnname as a
value in a variable or something like that
Hope someone understand
Regards
Alvin