All Questions
5 questions
1
vote
0
answers
47
views
Excell Cell Notes & Comments preventing shapes applied to cell from fitting correctly
I have an Excel worksheet that lists a variety of equipment, and uses a legend to associate different statuses with each piece of equipment using interior fill. This worked great until I realized some ...
- 141
0
votes
1
answer
197
views
Change the Color of shape and 3D formatting
I want different color formatting, using msoShapeStylePreset to apply color using RGB.
When I tried to apply the color using RGB, it filled the shape with two colors, which is not what I intended.
The ...
- 549
1
vote
1
answer
373
views
How to reset picture back from artistic effect in Excel VBA
I am trying to figure out something. I have a picture in my Excel file. Whenever I click on it I want it to become grayscale so I use the following vba code:
Sheets("Dashboard-3").Shapes(&...
- 379
0
votes
1
answer
9k
views
Trying to adjust size of shapes in VBA script but cannot get to size precisely
I am finding adjusting the size of shapes in Excel incredibly frustrating. For some reason, when I resize the height, the width adjusts to some random number, and vice versa. I do not have aspect ...
- 37
0
votes
1
answer
2k
views
How to format copied content from excel to PowerPoint? (Shape and Table Cell)
I have used VBA to copy values from Excel cells into table cells (tablename: "myTable", 2*2) and also into text for shapes (shape name "Oval11"). Now I want to format these as follows in PowerPoint ...
- 147