Search results

Hi, I need a macro that does the following (and would appreciate your help): 1. MsgBox saying "Your choice means ..." and in place of ... I would like the value in a particular cell. 2. Then I would like Yes and No options to appear below the above text in the message box. If you click No...

Thanks Somendra, this is helpful. Also thanks for Deepak and ThrottleWorks! Prompt and spot on.

Thanks, Thats very kind. However, I want one macro for all sheets (shown on the first sheet). Is that possible? Thanks ExcelStuff

Dear listers, I need to a macro (or a different solution) whereby all my sheets go on full screen view. Perhaps I can have the macro on the front sheet and then all sheets are visible in full screen mode. That would be really appreciated. Thank you! ExcelStuff

This is excellent stuff!!! I might come back with further minor tweaks but this is absolutely brilliant!

Dear Experts, I am using a slider to change values in a particular cell. Now depending on the value in the cell I would like to show shapes next to it (in a text box or cell or whatever). So for example if cell value is 10, I want to show a 5 green triangles, when its 8 then 4 triangles etc...

Thank you! This is a potential solution, although the whole frame changes when moving the slider but its a starting point. Thanks ExcelStuff

Thanks, Somendra, but it doesn't solve problem 1, i.e. I want the overall size of the pie to be bigger when the total sum of the two numbers is say 40 instead of 20. In your sheet, its currently showing me my percentages which I already have. Thank you!

Hi, I have two categories (say group A and B) and relevant numbers for each category. I am using a slider to change these numbers. Then I use a 3D pie chart to represent share of each group in the total pie. Now what I would like is that the pie should do two things: 1. The overall size of the...

Excellent! Thank you so much Debraj! This is great.

This is genius! Exactly what I wanted. Thank you, 'Big Man'!

Dear listers, I have several graphs on one screen and I want to be add a button or tab for which graph, so the user can click on it to show the graph and then click again to hide it. Can you advise on the best way to do this please? Thanks S

Thanks, Debraj. It worked for me, although I didn't want to expand but I cheated by first expanding to cover the white area and then dragged the whole chart inwards to resize it. It worked, although I don't like this solution. Thanks S

Dear users, I have a bar graph with a huge blank space on the right side. This happened when I moved the legends to the bottom of the graph. Obviously, resizing the graph doesn't help in anyway because it shrinks the whole graph. I would appreciate any advice. Thanks S

Thanks, Xiq, that's also a clever way to address this if one didn't have Excel 2010. Cheers.

Excellent! Great advice. Worked like a joy!

Hi, I have a bar graph which takes values from a slider. What I need is to show is that values below zero in the bar graph should be in red and above should be in green. The challenge is that as the slider moves, the values change (as above or below zero) and I want them displayed in different...

Actually that would be a neat thing to be able to do in Excel, i.e. list all comments in one sheet and you could change them on that sheet and it would update in relevant sheets/cells, although I am not sure about the utility of such function. I remain convinced that one should be able to get...

Thanks, Luke. It looks like the list comment macro in the second link you mentioned should do the trick, although its a shame that there is no built-in function to list all comments at the end of the sheet or in a new sheet. thanks for your help.

Hi, I have made several comments in a large Excel file and want to list them all in one sheet with sheet and cell references. Is there a way to do this? Many thanks

Excellent! Text box option works for me, albeit a way around the problem. Thanks, Dave. Hui: Unfortunately, there is no wrap text option on right click. The one on menu bar suggests it was inactive.

Hi, I want to change the vertical axis title of a bar graph from two lines to one line. Yes, I did change the font size but it has to be very small to be in one line (which is understandable). However, I noticed that in some charts the title was two lines long and in others it was one line...

Excellent cheeky solution :) Thank you!

Thanks, Luke. Very helpful. However, I want to introduce a new label (not the one associated with the data - so sort of a text box) and then add a value in it. Is this possible? Or maybe I could use the solution you suggested in my previous post (i.e. add a new data series with no fill/border)...

I am working with a bar graph and want to add an additional side label on the side of each bar to represent how much the value has reduced compared to the previous graph. Hence, the value in the side label will be equal to a formula. Is this possible to do in Excel? Thanks.