shape object

  1. T

    Drawing Shapes in Excel 2010 using XY Co-ordinates and Calculating the Subsequent Area of the Shape.

    Hello All, I am looking for a method of, having input a finite no. of XY coordinates in Excel 2010, to produce a shape (using straight connectors). I would then like the area of this shape to be calculated. Is there a method that I can use in Excel 2010 to do these? I have a rudimentary...
  2. B

    Find text in shape

    I am trying to use cube shapes to make physical a inventory system. I have named each of the cubes their location on the shelf and added text to each of those shapes defining what the product is on the shelf. I am a code the search for the text in the shape and resturn the name of the...
  3. F

    ShapeRange Group

    hi, I want to select two shape: CheckBoxes (ch) and Buttons (bt), and then simply group them. How can I select both??? 'ActiveSheet.shapes.range(array(bt,ch)).Select - but something is wrong here :( Selection.ShapeRange.Group.Select
  4. tweedle

    Lock my shapes from user resizing

    So I'm creating a bunch of shapes via vba that need to maintain their size as created, but allow the user to drag around (move) if need. I've been digging through shape properties and ShapeNodes but haven't found how to lock the shape from resizing. I need some direction/examples ... if...
  5. W

    Excel 2007 Selection.Characters.Text 1004 Error

    All, I have a macro that does some error checking on the user's input, changes the control/shape text and assigned macro, and then save the file to a SharePoint site. The problem arrises when the macro changes the control/shape text; for some people it works without issue (like myself) and for...
  6. P

    Macro command button gets Deleted

    I am new to this forum. I have an excel file with macros.I group all the shapes on a sheet.The command button and check boxes also gets included in it.When I delete the shape group the command button gets deleted.I just want to delete the shape group without the button and check boxes Any...

Some videos you may like

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top