ComboBox

[Abs]

I want to be able to extract data selected in a ComboBox.
In Excel, on a cell I am writing a formula to extract the content of the
comboBox1. The ComboBox1 has a list and the user has selected "Company" from
the list.
Now on a cell in Excel, I want to extract that selection. My attempts with
the following formulae do not work.
=Sheet1.ComboBox1.value.
Anyone can help please.

[Max]

If the Combobox is from the Forms toolbar,
with the Control tab settings, say:

Input range: $A$1:$A$5
Cell link: $B$1

then we could extract the selection made in any cell,
say in C4, with the formula: =INDEX(A1:A5,B1)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Abs" <[email protected]> wrote in message
news:[email protected]...
> I want to be able to extract data selected in a ComboBox.
> In Excel, on a cell I am writing a formula to extract the content of the
> comboBox1. The ComboBox1 has a list and the user has selected "Company"
from
> the list.
> Now on a cell in Excel, I want to extract that selection. My attempts with
> the following formulae do not work.
> =Sheet1.ComboBox1.value.
> Anyone can help please.

[Abs]

Thanks Max. I got the hint. I went and clicked on the properties of this
comboBox and then entered the cell number next to the Linked cell. It works
fine.
Regards

"Max" wrote:

> If the Combobox is from the Forms toolbar,
> with the Control tab settings, say:
>
> Input range: $A$1:$A$5
> Cell link: $B$1
>
> then we could extract the selection made in any cell,
> say in C4, with the formula: =INDEX(A1:A5,B1)
> --
> Max
> Singapore
> http://savefile.com/projects/236895
> xdemechanik
> ---
> "Abs" <[email protected]> wrote in message
> news:[email protected]...
> > I want to be able to extract data selected in a ComboBox.
> > In Excel, on a cell I am writing a formula to extract the content of the
> > comboBox1. The ComboBox1 has a list and the user has selected "Company"
> from
> > the list.
> > Now on a cell in Excel, I want to extract that selection. My attempts with
> > the following formulae do not work.
> > =Sheet1.ComboBox1.value.
> > Anyone can help please.
>
>
>

[Max]

Glad it helped, albeit indirectly <g> !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Abs" <[email protected]> wrote in message
news:[email protected]...
> Thanks Max. I got the hint. I went and clicked on the properties of this
> comboBox and then entered the cell number next to the Linked cell. It
works
> fine.