shapes

  1. L

    moving shapes with vba absolute X and Y coordinates

    Hi, In a previous post I read, it mentioned that it's possible to specify absolute coordinates for an excel shape e.g. rectangle. I've tried recording a macro whilst moving a shape around but to no avail, see below, ActiveSheet.Shapes("Rectangle 1").Select...
  2. J

    Moving Shapes in a Shared Workbook

    Hey there! This is my first post, and I really need some help. I've got a workbook with multiple tabs, with macros that move data back and forth between the various tabs. I need to enable multiple users to update the tool, so I set the workbook as "shared". All of the macros still work with the...
  3. S

    Adding a formula to a shape textbox with VBA

    I'm trying to select a shape by its name, in this instance the shape called "a" and enter a formula. The below code enters text just fine but I can't find a solution to allow me to enter a formula.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...
  4. K

    Formatting within a Shape

    I am using excel to produce a number of charts that are then copied and pasted into PowerPoint. All that works well. I then decided I needed a text box to add some additional explanition text. The code below does that and works well except it has a 0.38" Hanging Indent after the bullet. I...
  5. S

    Delete a shape using a macro

    Hello, I have a shape with instructions to enable macros when opening an excel document. Once users have enabled the macros I would like them to select a shape with a macro assigned to it that says "complete" and it will delete the instructions and the "complete button/shape." I tried...
  6. Jaafar Tribak

    Drawing Shapes on a UserForm .

    This is an attempt to add some basic shapes to an excel userform.The method I have used relies purely on API Region functions as opposed to the approach taken by andy pope who uses built-in excel shapes copied to image controls. The most difficult part is getting the regions to redraw when the...
  7. repairman615

    Transparent text in a shapes("TextBox 1")

    Hello, I have a textbox placed in the sheet from the insert menu. It is possible to set the transparency of the text manually...right click>format text effect>fill>transparency. Using vba, how could this be accomplished? Any insight is greatly appreciated. <font face=Courier...
  8. W

    Conditional Formatting for Dashboards

    I am building a dashboard that reviews inventory levels. I need to know if there is an easy way to use conditional formatting when using a connecting line from the Shapes Gallery (simple arrow line)? I would like this line to change colour based on inventory levels or conditions. Thanks Wyatt
  9. G

    Use shape to identify data in Bubble Chart

    I have a bubble chart. I use shapes, particularly the round shape, which I set to partially opaque and then use it to highlight data in the bubble chart. It looks like this: http://img834.imageshack.us/img834/1632/bubblez.png I would like to be able to generate a list of the points that are...
  10. B

    Can't call shape from Macro?

    I've drawn a shape that I'd like to use to trigger a macro, and have another shape beneath it (same size, same shape, slightly different properties to simulate a pressed button). Just to test, I wanted to use a macro to shift around the order of the shapes, so I modified code I'd used for a...
  11. D

    Shapes Shift in Different Views

    I am working on a Dashboard (in Excel 2007), and I've noticed that when I switch between Normal View and Page Layout View some shapes move in relation to each other. Does anyone know why that occurs, and if there is a fix?
  12. A

    Disable cut/copy of shape and images

    Hi all, I hope you can help me with this problem (I surfed a lot on the web but I couldn't find anything about it): I have to disable cut copy and paste in excel 2007 file expecially for images and shapes object. for istance, I want the user to be able to create an arrow, but I do not want him...
  13. J

    Event triggered when a shape is moved

    I have searched the forums for an answer to this and haven't found anything, but I am forever hopeful! Is there a way to trigger a macro when a shape is moved by the user? If I set the OnAction property for a shape, then the cursor changes to a hand when it is over the shape, and I can detect a...
  14. B

    List Shape Names on seperate worksheet

    Hello, I need a macro that will go through all the shapes on sheet1, and list the names on sheet2. Help please!
  15. C

    Worksheet Shape [textbox] Selection Event

    Hi, I have a worksheet with several text boxes, and when a specific text box is selected, I would like to run a macro. Much like what you might do using the Worksheet_Selection Change function. But, the Worksheet_Selection Change function seems to only respond to cell selection changes, not to...
  16. V

    Move Shapes

    When I create shapes using the ActiveSheet.Shapes.AddShape in VB code in excel, I have adjusted the locations to be exactly where I want the shapes relative to columns and other text. When I use the same code on a different computer, the shapes have moved relative the columns and other text and...
  17. B

    Assign text to shapes

    New to vba. I'm trying to assign shapes on sheet 1 with text in column A of sheet 1. i used the macro recorder and don't fully understand the executeexcel4macro line. thanks Sub Macro1() For i = 1 To 9 thistext = "Oval " & i thisrange = "=$A$" & i ActiveSheet.Shapes(thistext).Select...
  18. Avatar

    on Click of a Shape

    Greetings, I've run into a small problem with shapes.. Overview: I have an excel workbook that copies rows from one sheet to put into another sheet. The originating rows have 1 shape attached. On click of this shape, i want to to identify the row it is on, and delete it. The Problem: I've...
  19. B

    Drawing Class module with Form specs and sheet output

    I am struggling with establishing a class module to hold specifications for a Shape Rectangle for which some variable dimensions of the rectangle(Width and Height and colour) are to be provided from selections on a userform and then draw the rectangle on the spreadsheet and write the dimensions...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top