Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: axel67
  • Content: Threads
  • Order by date
  1. axel67

    Quick Treeview hint?

    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 =...
  2. axel67

    A real challenge for Dsum / Sumproduct in VBA

    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...
  3. axel67

    add custom category description to UDF

    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...
  4. axel67

    Possible to store and use a comparison operator in a variable?

    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...
  5. axel67

    Treeview issue for fullpath statement on hidden treeviews

    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...
  6. axel67

    Possible to add a &quot;Private Sub [Listbox]_Click()&quot; event at runtime?

    I have created an Excel user form (UserForm1) on which I am adding at run-time different listboxes (LB1 to LBn). These listboxes are based on named ranges on the worksheet and can as such vary each time the user form is loaded. I would like to add a click event to a) either all of those...

Part and Inventory Search

Back
Top