software

Hi,

I have a combobox that is linked to Range = A1:A11, using the RowSource =
A1:A11 in the properties window. The problem is that I launch the combobox
in a tab, and the range A1:A11 is in another tab. Is there anyway to specify
which tab the range A1:A11 is in.

The combobox launches from a chart and the range A1:A11 are the charts you
can choose.

Thanks

Just type in the name:

'Sheet 99'!a1:a11

Jeff wrote:
gt;
gt; Hi,
gt;
gt; I have a combobox that is linked to Range = A1:A11, using the RowSource =
gt; A1:A11 in the properties window. The problem is that I launch the combobox
gt; in a tab, and the range A1:A11 is in another tab. Is there anyway to specify
gt; which tab the range A1:A11 is in.
gt;
gt; The combobox launches from a chart and the range A1:A11 are the charts you
gt; can choose.
gt;
gt; Thanks

--

Dave Peterson