So that message box gives me the backcolor and forecolor, but can that be applied to this type code?
With ActiveSheet.Shapes("GC SC")
If Range("Ai5").Value = 1 Then
.Fill.ForeColor.SchemeColor = 10
ElseIf Range("Ai5").Value = 2 Then
.Fill.ForeColor.SchemeColor = 52...
I don't have any problem recording macros for cells, but when I record macro and format shapes, nothing happens. The code stays blank. What am I doing wrong?
Thanks
So I made a macro that colors certain shapes (terratories in the U.S.- poor man's GIS) based on numbers in cells. It works great, except that I'm forced to choose from the old, unappealing Excel 2003 colors. Is it possible to select the nice excel 2007 colors instead?
I have a dashboard that has a scroll bar on it and I copied this dashboard in order to make a similar one that uses different data. In the copied dashboard there is a small sliver of the scroll bar from the original dashboard that I cannot move or delete and it is driving me nuts. Has this...
I just don't understand why the code doesn't run when the results of the formulas in the cells change. Isn't that the whole point of the "change event" type macro?
So I think I understand what's going on. Since the cells containing the min/max/major units are based on formulas from another data source, the macro isn't recognizing that the cell are changing even when the formula results change. When I go to the cells containing the min/max/major unit and...
It doesn't seem to be doing anything. Do I need the "Option Explicit" at the top of the VBA code sheet? Would it make a difference that the chart has 2 axis?
Thanks for your response.
Well, last night when I was working on it, it was giving me an error message. I since changed the 'Chart.Axes(xlCategory)' code to 'Chart.Axes(xlValue)'. I thought that would make a difference, but now nothing happens when I change a cell on the page.
Here is...
Hello, I'm working on a dashboard that includes some charts that are changed via drop-down lists. That's simple enough, but the problem is the chart axis and the automatic scaling. There isn't a good fixed minimum that I can set the axis to, so I will need a macro to change the scale based on...