Ken -

If you have a single select listbox or combo, the cell link contains the
list index, that it, the index of the selected item. If multiple selected
items are enabled (extended or multiple selections), then list index is
undefined. But you can get the information out using VBA:

Sub Macro1()
Dim lst As ListBox
Dim b() As Boolean
Dim i As Long

Set lst = ActiveSheet.Shapes("List Box 1").OLEFormat.Object

ReDim b(1 To lst.ListCount)

For i = LBound(b) To UBound(b)
b(i) = lst.Selected(i)
Next

ActiveSheet.Range(lst.LinkedCell).Resize(lst.ListC ount).Value _
= WorksheetFunction.Transpose(b)
End Sub


- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______



"Ken Johnson" wrote in message
...
On May 6, 9:50 pm, "Jon Peltier"
wrote:
The Forms controls have been part of Excel for longer (I'm thinking Excel
4)
than the Controls Toolbox (Excel 97), so it stands to reason that they'd
be
more seamlessly integrated. Being newer, the ActiveX controls have richer
formatting possibilities. Both can link to cells and ranges in the
worksheet. Some advanced users have attributed buggy behavior to the
ActiveX
controls from the Controls Toolbox.

The Forms controls can be have macros assigned to them. The ActiveX
controls
have event procedures that run when they are clicked; these procedures
are
either inserted in the code modules of the objects (i.e., worksheets)
they
are embedded in, or written in class modules.

Forms controls can be used on chart sheets, ActiveX controls cannot.
ActiveX
controls do not work in MacExcel.

Excel responds to a Forms control after the user finishes interacting
with
it (i.e., unclicks). Excel responds continuously to an ActiveX control.
For
example, suppose a scrollbar is linked to a cell's value. If the control
is
a Forms slider, the user has to slide the bar on the control, then
release
it before the cell updates. If the control is an ActiveX Scrollbar, the
cell
updates continuously as the user slides the bar along the control.

In general I use the Forms controls, unless I need the continuous
response
of an ActiveX scrollbar.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

"funGT350" wrote in message

...

What is the difference Between a Forms Control versus an Active-X
Control?
(e.g. a Combo Box from the Forms Toolbar versus a Combo Box from the
Control
Toolbox Toolbar?) Why would one use one versus the other?

Hi John,

Any idea about the usefulness of the Multi and/or Extended Selection
properties of the Forms List Box. I can't figure out how to make them
work.

Ken Johnson