Search results for query: *

...created as the result of a formula" in the DSUM function. see article:( http://office.microsoft.com/en-us/excel/HP052090691033.aspx#Example7 ) **************************************** Criteria created as the result of a formula You can use a calculated value that is the result of a formula...

Sorry haven't done this yet. I know "they" exist but I thought I could just reference a node and then go through the list.... :-( I am already looking for hours but don't find any I understand. Do you have a "beginner" example? Thanks, Axel

Hi, Anyone has an idea how to loop through all the childs of a selected treeview node, which is not the root node but let's say 3rd level node? I did below but this just gives the direct children and does not further iterate into the remaining subchilds: Set nodx =...

I admit it is not easy to understand. If I come accross a good solution, I will share it here in the forum. Thanks for your thoughts so far. Cheers, Axel

...that you want to reference. In the following example, the formula contains a relative reference to cell B2 in the formula =MONTH(B2)=MONTH($H$3). **************************************** Now it would be of course great if it works when I genereate a cell that combines for example all...

Thanks Geoff, but I would like to avoid adding extra help calculation columns. That's what I have done alllways in the past, but I actually have different hierachical product groups. That means that I would need to create as many help columns as I have hierachy levels within one column...

Hi all, Here is a real challenge (which I can't cope).... I have the folowing table in Excel and I would like to report on combined criteria i.e. via DSUM or SUMPRODUCT: A B C 1 Product Staff Sales 2 P1 S2 10 3 P2 S3 5 4 P1 S1 15 5 P3 S1 20 6 P4 S3 5 7 P3 S2 10 8 P1 S3 15 For Example I would...

Hi, I came accross a procedure how to add to a UDF a function description as well as to set a new category (see below). But when I try that for my XLA project it does not work and I get the error 1004: Method 'MacroOptions' of object '_Application' failed. Sub AddCategoryDescription() Dim...

Thanks to all! This works great for numeric expression (my main purpose). I will have a look with the evaluate function, if it is possible to do also a textual comparison. Cheers, Axel

Hi, Does anyone know if it is possible to store comparison operators like "<=" in a variable and use them later in a comparison statement? Example: Function CellCompare(FirstCell As Range, SecondCell As Range, CompareOperator As Range) 'compare operator can be "=", "<>", "<=",..... CellCompare...

and solved... Need to add the "EnsureVisible" property to the node. Function GetTreeNodePath(LibaryName As String, DimensionName As String, DimItem As String) As Variant Dim objTree As TreeView 'name of the treeview: TVName = "TVDim" & LibaryName & "_" & DimensionName Set...

Hi weekend workers.... I have an issue with the treeview control (Excel 2000). I have a couple of treeviews on a form, of which only one is visible (depending on user selection. When the form is closed (hidden), I want to extract through a worksheet function the full path of a specific node...

Yeeeeeees it wooooorks (good that there is no sound attached.... :-) ) I did the following change to the code (had to decalare everywhere "MSForms.ListBox" ....): in the form code: Private colCB As Collection Private ctlCB As cCB Private Sub UserForm_Initialize() Set colCB = New Collection...

Yes Gerry, it is still listboxes on a user form and the code is still hanging....The sample comandbutton code from the FQA page works fine, but when I alter it to listboxes it doesn't do the job anymore. Is this a limit of VBA? Cheers....Axel

The first listbox click perfectly unhides the "second" listbox. But as per the code above, I do not get the click event for the second list box working. By the way do you know where to find information about using SQL on "worksheet databases"? Cheers, Axel

Hi Skip, I am not sure if I understand your suggestion. What I would like to do is to generate one Excel file that holds all my different hirachies in named ranges, and I can promise there are many ranges... The ranges hold the hirachy in two columns: first colum parent, secondcolumn child...

Just a little "justification", why I need to generate those listboxes at run time.... I am actally more a business user than a technical user, but I have some "binary" VBA skills. I love Excel for it's great analysis and presentation capabilities, but I am frustrated about the limited...

Thanks combo and the others who replied to my question. Combo, since I am new here, where can I find your VBA FAQ? Cheers, Axel

I do have a lot of different ranges to load from an initial "excel libary file". I'd rather load them once and have them available afterwards as this performs faster. I do have at the same time treeviews generetaed at run time that display the content of the worksheet ranges. The list boxes hold...

Hi Gerry, I am creating the boxes at run time (and filling them at run time). Cheers, Axel