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...
Hello, I've been working on a dashboard that has a few drop-downs, option buttons and scroll bars. I would like to protect the sheet so that the users don't mess with it, but once the sheet is protected, it won't allow you to select the dropdown options. Any suggestions?
I have a list of buildings and their energy usage trend. the list looks like this:
building % variance
xyz 12%
xzy -10%
yyz 30%
I need a formula that will pick out the buildings that have met a certain condition. So for example if I want to pick up all...
I am trying to create a dashboard that includes a bubble chart, but the data I am representing is in the size of the bubble, not the X,Y position. I would like to represent the other data via a color scale. aka a green bubble would have a better value than a red bubble. Is there any way to do...
So I'm creating a ranking index which uses a basic min/max formula to give a certain category a ranking out of 100. Each category is then weighted between 0 and 1 and the sum of the indicies multiplied by the weights then gives me my final index ranking.
So, I'm wondering if there's a way to...
I know there are literally dozens of pages about doing a countif with two conditions, but none of them work for me. I'm using excel 2003, so I can't us countifs. I need to count how many times the phrase "Total Operational" appears with a "0" in a column to the right of. I've tried the...
I work for an agency that manages buildings, and I have a nice looking distribution scatter-plot of the all of the building's energy performances. What I would like to do is add a field where you can enter the name of the building and then press a button and excel will highlight the building on...