Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
draw shapes in excel using the keyboard | Excel Discussion (Misc queries) | |||
Stacked Column Chart Data Label Connector Lines | Charts and Charting in Excel | |||
VBA to draw lines of SPC | Charts and Charting in Excel | |||
Excel Connector Lines | Charts and Charting in Excel | |||
How do I draw lines..?? | Excel Programming |