Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I change the color Excel Autoshape using VBA?
I'm trying to change the color of an Autoshape I've drawn on a spreadsheet
base on the value of a given cell. Can anybody help me? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I change the color Excel Autoshape using VBA?
hi Jmtricker
how about something like this: activesheet.shapes("yourshape").color = RGB(Cell1,Cell2,Cell3) the name and the correct syntax for the shape i would lookup with recording a macro and then putting it together. Although when you record a macro, excel always uses select, you can write it without the select. If there is any problem you can also post the code the recorded Macro and we can have a look at it. hth Carlo "jmtricker" wrote: I'm trying to change the color of an Autoshape I've drawn on a spreadsheet base on the value of a given cell. Can anybody help me? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I change the color Excel Autoshape using VBA?
Slight correction - the syntax is:
ActiveSheet.Shapes("yourshape").Fill.ForeColor.RGB = RGB(Cell1, Cell2, Cell3) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fill autoshape color with ref cell conditional formatting | Excel Worksheet Functions | |||
autoshape color conditional formating | Excel Discussion (Misc queries) | |||
change autoshape by condition from a cell value | Excel Discussion (Misc queries) | |||
How to change line spacing within an autoshape? | Excel Discussion (Misc queries) | |||
Change AutoShape Text Color in VBA? | Excel Programming |