I have about 20 sheets, each with about 400 shapes (rounded rectangles). These shape values (ex. "=A32", "=B12", "=E24") are referencing 8 columns and 50 rows in the sheet. These referenced cells are using INDIRECT to pull data from another sheet, which is using IFERROR(INDEX..., so there is...
I currently have static sized shapes, vba as follows:
If Not WorksheetFunction.IsNumber(ActiveWorkbook.Sheets("Configuration").Range("B25").Value) Then
CheckConfigItems = CheckConfigItems & "The Shape Size Value is Missing from the Configuration Sheet (Cell B25)" & vbCr & vbLf
Else...
Hi all
I currently have static sized shapes, however, would like to increase the size depending on a value in a range of cells eg if an issue is high then I'd like the shape to be bigger - this is what I currently have:
If Not...
I'm stuck. I can't find a way to protect my sheet while allow users to double click in a cell, use data validation list in the same cell while protecting shapes from being edited.
When I set DrawingObjects:=True the shapes are protected but I can no longer double click in a cell that has a data...
I have automated the creation of a PPT slide. However, the issue I run into arises when I run it on other computers. The size and positioning of the shapes seems to change ever so slightly, but noticeably. I have the shapes set to position themselves automatically based on original position...
This is weird.
I have a worksheet that is generated by another piece of software (it's web-based, I don't know).
On this Excel sheet, I have:
Conditional formatting that changes the fill color and the text color
Text that, after it's been imported, I manually change the color
An imported...
Hi, I developed a macro to change shapes colors based on the value of a cell. Originally I wrote this code
ActiveSheet.Shapes.Range(Array("Col")).Select
If Range("D69") = "0" Then
Selection.ShapeRange.Fill.ForeColor.RGB = RGB(127, 127, 127)
ElseIf Range("D69") = "1" Then...
Good afternoon,
In an attempt to solve another's problem, I am playing with shapes. I am trying to detect overlapping shapes created through vba on demand. I have a list of x and y coordinates and convert those to a position on a chart.
The problem I am running into at the moment, is that...
Hello All,
Through searches int his forum, I was able to use an Excel VBA code to produce shapes on another worksheet per Cell Value. Everything seems to work perfectly but the shapes are side-by-side. Is there a way to have the first to cell value shapes on top and the others in the bottom...
Dear Users,
1. I have a dynamic list of organisations.
Through VBA I insert a rectangle as shapes.
Set s = Worksheets("Tabelle1").Shapes.Addshape(62, 70, 120 150, 30)
Simultaneously I assigned the created shape a macro through
s.OnAction ="Macro"
2. Later this macro should plot data...
Hello everyone,
As I add levels using the text pane to my labeled hierarchy chart the shapes do not move or resize to remain in the labeled level.
How do I keep them in the correct levels?
Hi Gurus,
I am having an issue trying to hide/unhide columns using shapes (not command buttons). I would like to do the following:
1) have the shapes show a "ON" color and "OFF" color (which I have tried to do by overlapping shapes on top of each other
2) when a certain shape is "ON", the...
Hi, I happened to stuck with one problem for my project. Basically what I'm trying to do is hide and show shapes containing macro. To illustrate, so each shapes has their own set of sub-shapes (let's say there are 3 shapes with each has their own 2 sub-shapes). What i have in mind is that each...
Just idly curious. I can't access a shapes properties unless the sheet is activated. I'm guessing the process of activating the sheet loads the sheet shapes into accessible memory, but why? Are the sheet's shapes and properties stored in an abbreviated form that is only expanded to accessible...
Hello guys. Im new to Excel VBA and i need help with a problem im trying to solve.
I have 2 shapes and when i click the shapes the same userform appears. The value that are typed in the userform is gonna be placed in a different cell wich depends on what shape is clicked.
The code i have...
Hi
I've got a weird problem. I've got code to connect 2 shapes with an elbow connector using a function with start and end shape as parameters.
Dim conlink as Shape
...other code
conLink = AddElbowConnector(shpSourceSheetShape, shpTargetSheetShape)
Both shapes exist and the first time...
I dynamically generate Org Charts using the SmartArt CirclePictureHierarchy object, but I am unable to export them as PDF files in code.
I thought I could use the same code as I use to export a Chart, but that didn't work.
I believe exporting Shapes is doable, but I can't capture the code in a...
Hello,
Does anyone have VBA code whichselects all shapes in a workbook and then sizes them the same height and width(1 in X 1in). The shapes are embeddedDocuments and Packager Shell Object
Below is code where I am splitting atable into multiple sheets. The splitworks great with one...
Hello,
I have code that will make spaces between the shapes but I cant seem to get this code to select range on one page and paste it on another page with the blanks between the shapes.
The shapes have no names.
code:
Sub InsertBlankRows()
Dim Rng As Range
Dim WorkRng As Range
Dim FirstRow...
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.