Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Macro assigned to rectangle3
Sub colorshp() With ActiveSheet.Shapes("Rectangle 3") ..Select Selection.ShapeRange.Fill.ForeColor.SchemeColor = 12 Range("g19").Value = 25 Selection.ShapeRange.Fill.ForeColor.SchemeColor = 13 End With End Sub -- Don Guillett Microsoft MVP Excel SalesAid Software "Terje" wrote in message ... I am using a shape as a button in form controls, I have assigned a macro to this shape to change a set of data. How can I get the shape to change fill color when running this macro? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Shape color macro | Excel Discussion (Misc queries) | |||
Separating scatterplot points by color and shape | Charts and Charting in Excel | |||
shape color | Excel Discussion (Misc queries) | |||
How do I color only half of shape? | Excel Worksheet Functions | |||
How do I set up an Excel shape to "fill" with a color | Excel Discussion (Misc queries) |