Getteing the collum name

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" <alvinKuiper@discussions.microsoft.com> wrote in message
news:A9AD9807-9DDE-42B3-A458-C9F2B909BD07@microsoft.com...
> 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" <alvinKuiper@discussions.microsoft.com> wrote in message
> news:A9AD9807-9DDE-42B3-A458-C9F2B909BD07@microsoft.com...
> > 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
> >
>
>
>