Is it possible for a UDF to automatically list the necessary variables
below the Functions bar?
For example, when using Excel's "LEFT" function the following appears
below the Functions bar while typing the formula: "LEFT(text,
[num_chars])".
If possible please inform of how to accomplish. Thank
You can copy paste the following procedure in the worksheet. In the VBA
editor (VBA project) double click the relevant sheet and paste the module
below.
'
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("A1")).Rows.Count = 1 Th
The attached file demonstrates what you describe. I created a directory
C:\FactSheets containing ten Workbooks FactSheet 1 - FactSheet 10 as test
data. OpenFile contains a comboBox that allows you to open one or more of
the FactSheets. The code for the comboBox is as follows:
Private Sub ComboBox
What you describe is best accomplished by a macro rather than a formula .
Take a look at the attached function (GetValue). If you have any
questions let me know
Tom
On Sat, Dec 6, 2008 at 3:31 PM, watmatt <[EMAIL PROTECTED]> wrote:
>
> Can you help me please? I have a bit of a situation and I
I played with Excel/VBA until I built a Google Insights data and data
pairs scraper. If anyone wants to tinker with them, their available
for download at:
http://precisiondatamining.net/
Do read the notes at the bottom of the link as to what directory I
chose to dump the data.
Cheers,
Alex
-
You can Use this
=SUMPRODUCT((B2:B13>0)*(D2:D13))
Regards
Aman S Arora
From: excel-macros@googlegroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Tom Jeffries
Sent: Saturday, December 06, 2008 2:40 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macr
Try the following formula
=B2+B2*INDEX({-0.05,-0.03,0,0,0,0.4,0,0.5},MATCH(A1,{2000,1000,500,499,100,9
9,50,49},-1))
Values Of A1 Operation
==
Upto 49 B2 * 50%
50 Unchanged
51 to 99B2 * 40%
100 to 500 Un
