Recent content by RobSA

Hi Folks, I have created a ribbon that looks like the attached image. However when I want to add macros, I select "customise ribbon" I do not see the name of the ribbon appearing in the list. How do I set about the process of getting the TAB"Epoch" included, so that I may assign my macors?

Hi Grah, Thanks for your reply. The problem I had was that the ranges in the x axis were different. I have solved the problem.

Hi Folks, I have created an S-Curve (chart) with date on the X-axis and percentages on the Y-axis. I have inserted a vertical line using and error bar, to represent todays date and it is marked as a secondary axis. The challenge that I have, is that when doing so the range changes on the...

Hi Belleke, Thank you for your reply. IT is not quite what I was looking for. I have have attached a picture that might help. In providing a description - if I select the SANS icon a drop down list appears of pdf documents I have on my computer. In this case if I select 1200 C a user form...

Hi Folks, I am developing a custom ribbon and require some assistance. When I hover over an icon in the ribbon the supertip will reveal what the buttton will do if selected. If I select the button in the ribbon I wish for it to open a pdf in a userform, with scrollable bars, thus allowing me...

Hi Folks, I am trying to create a progress report which shows charts and some text. The spreadsheet has over 200 worksheets and numbered in multiples of 20, ie 20,40,60,80,100,120,140,etc. The idea is to fetch the charts selectively from 40-100 and have them show in a report. I am not sure...

p45cal, Thanks very much. This works like a dream. Without asking to much, what was I doing wrong that the number was not reading correctly?

Thanks Pavan.I will give it a look.

I have checked the option of copying the number to another cell as suggested. If I copy and paste the result is 0.000. If I copy and paste values the result is 118.1158 If I copy paste using formula the result is also 0.000 The result I would like to see is 118.1158 rounded to the third...

Hi folks, I have several macro's which I would like to include into a ribbon icon, to make executing the macro easier. I would be appreciative of any info.

Hi Folks, I have a scatter chart with serveral lines included. I wish to shade between some of the lines and looking for a way on how to do this. Any help here would be welcome

HI Vletm, I have looked at the values. The values in the varies worksheets all are a result of a formula (Pythagoras) and the results of this formula have values that do not only end with .000 but with other variations. It is these exact values I wish to appear in my "Sheet4". It may be that...

Ok so now I have worked on this excercise, my challenges are as follows: The value that have been garnered from the various worksheets, does not display the decimal value and they are rounded off to reflect as 4.000 for example instead of 4.235. My work so far Dim erow, MyValue As Long For...

Hi Folks, I have a workbook with over 300 pages. the pages however have data in a common cell which I would like to extract, into a single list. thats the first challenge. The second is to inquire whether this list would be dynamic, as it is possible that the data in the individual...