how to draw lines and more from drawing tools in excel using vb.net-VBForums
Results 1 to 4 of 4

Thread: how to draw lines and more from drawing tools in excel using vb.net

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 2011
    Posts
    36

    how to draw lines and more from drawing tools in excel using vb.net

    hi all

    i would like to know how to draw figures in excel programically with lines from drawing tools of excel using vb.net (as in attached pdf file).
    So can any one guide me how to do it with an example?

    thanks in advance
    gvg
    Attached Images Attached Images
    Last edited by gvgbabu; Oct 6th, 2017 at 04:14 AM.

  2. #2
    eXtreme Programmer .paul.'s Avatar
    Join Date
    May 2007
    Location
    Chelmsford UK
    Posts
    21,472

    Re: how to draw lines and more from drawing tools in excel using vb.net

    I don't understand the question...
    If you want to draw in excel, it's a VBA question, and you should ask in the Office Development Forum

  3. #3

    Thread Starter
    Member
    Join Date
    Jul 2011
    Posts
    36

    Re: how to draw lines and more from drawing tools in excel using vb.net

    thank you paul
    I am writing an excel through vb.net program. I want to draw a diagram in excel with writing. i think it is not a VBA question.
    any example how to do it with excel drawing tools through vb.net.

  4. #4
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    39,254

    Re: how to draw lines and more from drawing tools in excel using vb.net

    If you know how to manually do the kind of things you want to do, you can get Excel to tell you the code you need... simply record a macro and perform the actions.

    The code won't be quite right for .Net , but it doesn't take too much work to modify it to use your object variables for the worksheet etc, and to use the .Net versions of the constants.

    If you get stuck, show us the macro and your .Net version, and let us know the issue(s).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.