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

Hi Alvin

Set the Combobox's ColumnHeads property to true.


---
Regards,
Norman


"alvin Kuiper" wrote in message
...
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

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



"alvin Kuiper" wrote:

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

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

"Norman Jones" wrote:

Hi Alvin

Set the Combobox's ColumnHeads property to true.


---
Regards,
Norman


"alvin Kuiper" wrote in message
...
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