Search:

Type: Posts; User: rory; Keyword(s):

Page 1 of 20 1 2 3 4

Search: Search took 0.08 seconds.

  1. Replies
    0
    Views
    59

    Sticky: VBA Language Specification Document

    Sure - you can download the PDF here: http://download.microsoft.com/download/0/a/6/0a6f7755-9af5-448b-907d-13985accf53e/[ms-vbal].pdf
  2. Replies
    17
    Views
    432

    It's always worth looking in the Language spec...

    It's always worth looking in the Language spec document. It takes a little while to get used to some of its syntax, but it's a mine of useful information!
  3. Replies
    17
    Views
    432

    Per the VBA Language specification for Array...

    Per the VBA Language specification for Array Dimension and Bounds (sect 5.2.3.1.3):


    Note that the lower bound is optional, the upper is not.

    Hence, any array declaration that only provides...
  4. Thread: Counting Formula

    by rory
    Replies
    22
    Views
    478

    Thank you. :)

    Thank you. :)
  5. It would help if you posted your code. There is...

    It would help if you posted your code. There is no Excel setting for 'create workbooks if they don't exist' and Workbooks.Open has always failed if you pass a non-existent file path, so I suspect...
  6. Thread: Counting Formula

    by rory
    Replies
    22
    Views
    478

    In that case I think you need: ...

    In that case I think you need:

    =SUMPRODUCT((C3:C7<>"")*(SUBTOTAL(3,OFFSET($B$3,ROW($B$3:$B$7)-MIN(ROW($B$3:$B$7)),0,1,COLUMNS($B2:C2)))=1))

    I don't think any of the prior formulas will...
  7. Thread: Counting Formula

    by rory
    Replies
    22
    Views
    478

    To do it without a helper column: ...

    To do it without a helper column:

    =SUMPRODUCT((C3:C7<>"")*(SUBTOTAL(3,OFFSET($B$3:$F$3,ROW($B$3:$B$7)-MIN(ROW($B$3:$B$7)),0))=1))

    One question though: if there is no value in col A, but a value...
  8. Replies
    3
    Views
    117

    You don't need any. Simply adding the command bar...

    You don't need any. Simply adding the command bar controls should make the addins tab visible.
  9. Replies
    3
    Views
    117

    The add-ins tab only shows when you have custom...

    The add-ins tab only shows when you have custom commandbar code.
  10. Replies
    3
    Views
    130

    You can't run code while a user is editing a...

    You can't run code while a user is editing a cell. Even a Windows API timer won't get around that.
  11. Thread: formula help

    by rory
    Replies
    6
    Views
    180

    You're welcome. :)

    You're welcome. :)
  12. Thread: formula help

    by rory
    Replies
    6
    Views
    180

    Then in C2: =IF(A2=A1,IF(C1

    Then in C2:
    =IF(A2=A1,IF(C1<4,C1+1,""),1)
    and copy down.
  13. Thread: formula help

    by rory
    Replies
    6
    Views
    180

    Are they sorted by code?

    Are they sorted by code?
  14. Looks to me like you only need one condition:...

    Looks to me like you only need one condition:
    =AND($J$3="Closed",$S$3="")
    to format it red.
  15. Replies
    9
    Views
    153

    [SOLVED] :)

    :)
  16. Replies
    9
    Views
    153

    [SOLVED] Yes I did. You didn't assign a macro to the...

    Yes I did. You didn't assign a macro to the spinner, which is why you don't get a hand.
  17. Replies
    9
    Views
    153

    [SOLVED] Not for me. Gives the hand pointer by default.

    Not for me. Gives the hand pointer by default.
  18. Replies
    9
    Views
    153

    [SOLVED] The easiest workaround I can think of is to...

    The easiest workaround I can think of is to assign a macro that doesn't do anything to the control.
  19. Replies
    1
    Views
    110

    Excel 2016 has Get and Transform (previously...

    Excel 2016 has Get and Transform (previously known as Power Query) built into it, which is a very powerful tool for extracting data from all sorts of sources (though it can get complicated, by...
  20. The first part sounds like you simply want to...

    The first part sounds like you simply want to multiply the score by 95%

    The second you want to divide the passing grade by 95%
  21. I'm not clear what you want. As it stands, it...

    I'm not clear what you want. As it stands, it appears that you simply want to return the score capped at 95?
  22. If it's the only sheet, try replacing those three...

    If it's the only sheet, try replacing those three lines with this one:

    Workbooks("Layout Sheet.xls").Worksheets(1).PageSetup.PrintArea = ""
  23. There's a simple example here:...

    There's a simple example here:...
  24. Replies
    49
    Views
    1,214

    Private Declare PtrSafe Function...

    Private Declare PtrSafe Function GetWindowThreadProcessId Lib "user32" (ByVal hWnd As Long, lpdwProcessId As Long) As Long
    hWnd should be a LongPtr because it's a window handle. And the same in the...
  25. Replies
    49
    Views
    1,214

    Just noticed you also seem to be missing the...

    Just noticed you also seem to be missing the UnhookWinEvent declaration.

    I don't have 64bit here to verify, but I think the correct declarations for 64bit only are:

    Private Declare PtrSafe...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4