Getteing the collum name

[Guest]

Hi
I use a combobox with name from a row
in row a i have several name "Headklines"
its working allright
When i choose a name in the combobox i want to
get the collum name not the value from the combobox
can i do that?

Like if row 1 have headlines like :

Text1 , text2 , text3 and son on
Then i get this value in combobox
now i want to see where "text3" like collum c Or E Or g.

Regards alvin

 

[Norman Jones]

Hi Alvin

Set the Combobox's ColumnHeads property to true.

 

[Guest]

HAve a little bit more information to this Question

My combobox get the value from a name range
And when i choose a name from the combobox i
insert the vlue in a cell like "I1"

So i think this way

result = Selection.Address in my namerange where name = "I1"

Or something like that???

Alvin

 

[Guest]

I'm not so god to thsi here
When i have
Set the Combobox's ColumnHeads property to true.
then what
how can i see this
Alvin