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