Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 298
Default cant draw connector lines between 2 shapes

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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default cant draw connector lines between 2 shapes

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" wrote in message
...
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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,565
Default cant draw connector lines between 2 shapes

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


"Rich" wrote in message
...
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



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 298
Default cant draw connector lines between 2 shapes

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" wrote in message
...
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



.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
draw shapes in excel using the keyboard abslv Excel Discussion (Misc queries) 1 October 7th 09 06:54 PM
Stacked Column Chart Data Label Connector Lines Erik Charts and Charting in Excel 4 June 5th 09 11:55 PM
VBA to draw lines of SPC Daniel Charts and Charting in Excel 4 July 31st 07 08:44 PM
Excel Connector Lines JeffinDallas Charts and Charting in Excel 0 January 10th 05 05:01 PM
How do I draw lines..?? MIKEB Excel Programming 4 October 24th 03 12:22 AM


All times are GMT +1. The time now is 07:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"