Results 1 to 4 of 4

VBA to add shapes

Threaded View

  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:

     ActiveSheet.Shapes.AddShape(msoShapeRectangle, 52, 537, 130, 23).Select
        Selection.ShapeRange.Fill.ForeColor.SchemeColor = 1
        Selection.ShapeRange.Fill.Solid
        Selection.ShapeRange.Fill.Visible = msoTrue
        Selection.ShapeRange.Line.ForeColor.SchemeColor = 5
        Selection.ShapeRange.Line.Weight = 3#
        Selection.ShapeRange.TextFrame.Characters.Font.Name = "Arial"
        Selection.ShapeRange.TextFrame.Characters.Font.Size = 10
        Selection.ShapeRange.TextFrame.Characters.Font.Bold = True
        Selection.ShapeRange.TextFrame.Characters.Font.ColorIndex = 1
        Selection.ShapeRange.TextFrame.HorizontalAlignment = xlHAlignCenter
        Selection.ShapeRange.TextFrame.VerticalAlignment = xlVAlignCenter
    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.

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. 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