eXceL 2003 - list or combo box question

[David Gerstman]

I'm trying to incorporate either a list box or a combo box into a spreadsheet.
(My source is How to Programmatically Insert Data from a List Box into the
Active Cell at
http://support.microsoft.com/default...n-us%3BQ213363 )
One of the instructions is to right click on the list box and go to the
Format Control menu. The problem I have at this point is that there is no
"Control" tab in the dialog box. Is that because the instructions are for
Excel 2000 and I'm working in Excel 2003 where the control is no longer
handled the same way?

[Chip Pearson]

Are you using the listbox control from the Forms command bar or
the Controls command bar. Despite the same name, the controls are
quiet different.


"David Gerstman" <dhgerstman@NOSPAM.hotmail.com> wrote in message
news:7122C6FB-28E3-4F71-9006-F036235F740E@microsoft.com...
> I'm trying to incorporate either a list box or a combo box into
> a spreadsheet.
> (My source is How to Programmatically Insert Data from a List
> Box into the
> Active Cell at
> http://support.microsoft.com/default...n-us%3BQ213363 )
> One of the instructions is to right click on the list box and
> go to the
> Format Control menu. The problem I have at this point is that
> there is no
> "Control" tab in the dialog box. Is that because the
> instructions are for
> Excel 2000 and I'm working in Excel 2003 where the control is
> no longer
> handled the same way?
>

[David Gerstman]

Thank you very much chip.
I see I still have quite a bit to learn. I also hope that I remember this
bit of info.
David

"Chip Pearson" wrote:

> Are you using the listbox control from the Forms command bar or
> the Controls command bar. Despite the same name, the controls are
> quiet different.
>
>
> "David Gerstman" <dhgerstman@NOSPAM.hotmail.com> wrote in message
> news:7122C6FB-28E3-4F71-9006-F036235F740E@microsoft.com...
> > I'm trying to incorporate either a list box or a combo box into
> > a spreadsheet.
> > (My source is How to Programmatically Insert Data from a List
> > Box into the
> > Active Cell at
> > http://support.microsoft.com/default...n-us%3BQ213363 )
> > One of the instructions is to right click on the list box and
> > go to the
> > Format Control menu. The problem I have at this point is that
> > there is no
> > "Control" tab in the dialog box. Is that because the
> > instructions are for
> > Excel 2000 and I'm working in Excel 2003 where the control is
> > no longer
> > handled the same way?
> >
>
>
>