+ Reply to Thread
Results 1 to 4 of 4

VBA to add shapes

  1. #1
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    O365
    Posts
    69

    VBA to add shapes

    Hi all again,

    So I'm currently trying to create yet another form, luckily my department has made some interesting macros / VBA's before and since I still haven't received a proper VBA training all I can do is either google search, this forum or "reverse engineer" the others.

    I've stumbled across this thing:

    Please Login or Register  to view this content.
    Which creates a certain shape, but let's say that I already have some shapes, special ones, can I somehow find out their properties so I could instead create them?

    Thanks
    Last edited by Martines91; 10-02-2019 at 05:27 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: VBA to add shapes

    Hi
    please use code tags (#button) instead of quote tags. Thanks

  3. #3
    Forum Expert KOKOSEK's Avatar
    Join Date
    08-03-2018
    Location
    Pole in Yorkshire, UK
    MS-Off Ver
    365/2013
    Posts
    2,743

    Re: VBA to add shapes

    Try like this:
    Please Login or Register  to view this content.
    you can add any parameters which you need.

    edit: setting instead of check and display. Corrected.
    Last edited by KOKOSEK; 10-01-2019 at 08:54 AM.
    Happy with my answer * Add Reputation.
    If You are happy with solution, please use Thread tools and mark thread as SOLVED.

  4. #4
    Registered User
    Join Date
    11-17-2015
    Location
    Nitra, Slovakia
    MS-Off Ver
    O365
    Posts
    69

    Re: VBA to add shapes

    Interesting, thanks but will that give me like.. everything? Size, format (3d bevels, color etc.) and others?

    edit: I can work with this further, thanks
    Last edited by Martines91; 10-02-2019 at 05:27 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 08-11-2017, 03:05 PM
  2. excel 2013 customize context shapes and shapes group menu right click
    By Giuseppe77 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-03-2016, 11:50 AM
  3. excel 2013 customize context shapes and shapes group menu right click
    By Giuseppe77 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 12-03-2016, 11:50 AM
  4. [SOLVED] followup top shapes as one colour, exclude 2 shapes
    By deancorleone in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-01-2013, 02:14 PM
  5. Shapes based on Cell Data, Golf Score card data that shows shapes around scores
    By BiggDC1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-12-2012, 12:42 PM
  6. How To Move Shapes From Another Shapes? (floating shapes)
    By MarcLev in forum Word Programming / VBA / Macros
    Replies: 2
    Last Post: 10-04-2009, 04:04 PM
  7. [SOLVED] How can i get more 3D shapes for Auto shapes in excel?
    By Ajey in forum Excel General
    Replies: 0
    Last Post: 03-03-2005, 06:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1