$$Excel-Macros$$ Re: Boxplots in Excel 2010

2013-01-10 Thread Adrian Teodorescu
Forgot to say: You need to select at least one column with at least 5 rows, excluding the title row (which also needs to be selected) On Thursday, January 10, 2013 12:57:01 PM UTC+1, Adrian Teodorescu wrote: > > This is a rudimentary (and not thoroughly checked) graphical > represen

$$Excel-Macros$$ Boxplots in Excel 2010

2013-01-10 Thread Adrian Teodorescu
This is a rudimentary (and not thoroughly checked) graphical representation of data as a boxplot. It does not check the outliers using Grubb's test however shows outliers that are farther than 1.5 IQR. Looking for ideas on improving it. Copy and paste the code into a new module and run the macr

$$Excel-Macros$$ Roman to Arabic

2013-01-10 Thread Adrian Teodorescu
This is a rather rudimentary conversion of Roman numerals into Arabic (inverse of ROMAN function in Excel 2010) Just copy the code and paste it into a new module. then in excel cell, type = Arabic("xxx") where xxx is the Roman numeral (e.g. MMDX) -- Join official Facebook page of this forum @

$$Excel-Macros$$ Re: Problem with duplicating a Shape and defining OnAction property

2009-07-21 Thread Adrian
Instead of trying to fix this problem, could anyone tell me how I could make multiple images execute the same code but with a different parameter upon clicking? --~--~-~--~~~---~--~~ --

$$Excel-Macros$$ Problem with duplicating a Shape and defining OnAction property

2009-07-21 Thread Adrian
Hello all, I was wondering if anyone could tell me why, when I Duplicate a Shape (image), I can't assign OnAction property to it. Following is a simple code that gives me "Run-time error 1004: Application-defined or object- defined error": Sub Image1_Click() Dim new_shape As Excel.Shape

$$Excel-Macros$$ Re: How can a custom function know which cell its in?

2009-07-17 Thread Adrian
on > > and then in any cell type =WhatsMyRow(A1)   the cell will show 1 > > On Jul 17, 5:22 pm, Adrian wrote: > > > > > Is there a way to create a custom function that will print out row > > number that the function is in? > > > For example, in cell C5, I'

$$Excel-Macros$$ How can a custom function know which cell its in?

2009-07-17 Thread Adrian
Is there a way to create a custom function that will print out row number that the function is in? For example, in cell C5, I'll type '=whats_my_row_number()' and I would like it to say 5. Thank you in advance, --~--~-~--~~~---~--~~ --