at

http://office.microsoft.com/en-us/ex...922291033.aspx

it shows how to draw a connector line(s) - says applies to Excel 2003 (which
I am using Excel 2003). I follow the instructions (below) but no connector
line appears. Why would this be?

-On the Drawing toolbar, click AutoShapes, point to Connectors, and then
click the connector line you want.

-Point to where you want to attach the connector.

-Connection sites appear as blue circles as you pass the pointer over a shape.
(I am not getting the blue cirlces here)

-Click the first connection site you want, point to the other object, and
then click the second connection site.

-Locked or attached connectors appear as red circles. Unlocked connectors
appear as green circles. (the only green cirlce I get is when I select the
shape and the green cirlce is for rotating the shape).

Somewhere I am missing something. What am I missing?

Thanks,
Rich

It works for me. I just connected a combobox to a textbox on a sheet.
Haven't tried it on a form. Be sure you use the connector lines and not
just regular lines. The lines must be attached at the connection points on
the shapes, which appear as little blue dots.



"Rich" <(E-Mail Removed)> wrote in message
news:62688DE1-19AF-477C-8C20-(E-Mail Removed)...
> at
>
> http://office.microsoft.com/en-us/ex...922291033.aspx
>
> it shows how to draw a connector line(s) - says applies to Excel 2003
> (which
> I am using Excel 2003). I follow the instructions (below) but no
> connector
> line appears. Why would this be?
>
> -On the Drawing toolbar, click AutoShapes, point to Connectors, and then
> click the connector line you want.
>
> -Point to where you want to attach the connector.
>
> -Connection sites appear as blue circles as you pass the pointer over a
> shape.
> (I am not getting the blue cirlces here)
>
> -Click the first connection site you want, point to the other object, and
> then click the second connection site.
>
> -Locked or attached connectors appear as red circles. Unlocked connectors
> appear as green circles. (the only green cirlce I get is when I select
> the
> shape and the green cirlce is for rotating the shape).
>
> Somewhere I am missing something. What am I missing?
>
> Thanks,
> Rich
>

Nope, the drawing toolbar will not work in the VBE, so connectors will not
work on a UserForm.


"Rich" <(E-Mail Removed)> wrote in message
news:62688DE1-19AF-477C-8C20-(E-Mail Removed)...
> at
>
> http://office.microsoft.com/en-us/ex...922291033.aspx
>
> it shows how to draw a connector line(s) - says applies to Excel 2003
> (which
> I am using Excel 2003). I follow the instructions (below) but no
> connector
> line appears. Why would this be?
>
> -On the Drawing toolbar, click AutoShapes, point to Connectors, and then
> click the connector line you want.
>
> -Point to where you want to attach the connector.
>
> -Connection sites appear as blue circles as you pass the pointer over a
> shape.
> (I am not getting the blue cirlces here)
>
> -Click the first connection site you want, point to the other object, and
> then click the second connection site.
>
> -Locked or attached connectors appear as red circles. Unlocked connectors
> appear as green circles. (the only green cirlce I get is when I select
> the
> shape and the green cirlce is for rotating the shape).
>
> Somewhere I am missing something. What am I missing?
>
> Thanks,
> Rich
>

The little blue dots. Yes. Now it is working! Thanks.

"JLGWhiz" wrote:

> It works for me. I just connected a combobox to a textbox on a sheet.
> Haven't tried it on a form. Be sure you use the connector lines and not
> just regular lines. The lines must be attached at the connection points on
> the shapes, which appear as little blue dots.
>
>
>
> "Rich" <(E-Mail Removed)> wrote in message
> news:62688DE1-19AF-477C-8C20-(E-Mail Removed)...
> > at
> >
> > http://office.microsoft.com/en-us/ex...922291033.aspx
> >
> > it shows how to draw a connector line(s) - says applies to Excel 2003
> > (which
> > I am using Excel 2003). I follow the instructions (below) but no
> > connector
> > line appears. Why would this be?
> >
> > -On the Drawing toolbar, click AutoShapes, point to Connectors, and then
> > click the connector line you want.
> >
> > -Point to where you want to attach the connector.
> >
> > -Connection sites appear as blue circles as you pass the pointer over a
> > shape.
> > (I am not getting the blue cirlces here)
> >
> > -Click the first connection site you want, point to the other object, and
> > then click the second connection site.
> >
> > -Locked or attached connectors appear as red circles. Unlocked connectors
> > appear as green circles. (the only green cirlce I get is when I select
> > the
> > shape and the green cirlce is for rotating the shape).
> >
> > Somewhere I am missing something. What am I missing?
> >
> > Thanks,
> > Rich
> >
>
>
> .
>