Recent content by axel67

I found an interesting solution, for those who might be interested.... In the microsoft help for the DSUM function it shows that you can use "Criteria created as the result of a formula" in the DSUM function. see article:( http://office.microsoft.com/en-us/excel/HP052090691033.aspx#Example7 )...

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

Thanks for the responses! Combo do you have any link I can use for reading to make myself knowlegable about the MS Query in VBA? I have pulled out an article that describes "Computed Criteria" in DSum. ( http://support.microsoft.com/kb/282851/ ) They use the following example: In the formula...

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