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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top