View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default How do I draw lines..??

A good start would be to turn on the macro recorder (tools=Macro=Record a
New macro)

then draw you lines manually. Change things as you would want. Turn off
the macro recorder and look at the code.

This is a good start at looking at what attributes and methods were
employed.

--
Regards,
Tom Ogilvy

"MIKEB" wrote in message
...
Question is, how do I go about drawing lines in Excel with VBA? I want
to draw a line using the drawing tool, not Borders and Shading. Where
would I get more info on Drawing Objects. Any help would be greatly
appreciated.






------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/