Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |