Search:

Type: Posts; User: Jaafar Tribak; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.31 seconds.

  1. Re: Which Range is currently being Cut or Copied ?

    This worked for me :

    In a Standard Module:

    Option Explicit

    #If VBA7 Then
    Declare PtrSafe Function OpenClipboard Lib "user32" (ByVal hwnd As LongPtr) As Long
    Declare PtrSafe...
  2. Re: Which Range is currently being Cut or Copied ?

    Wow!! I never thought this question was asked so many times before .

    Thanks for the links.

    I'll take the Windows API route and see if that will offer a solution.
  3. Which Range is currently being Cut or Copied ?

    Hi dear forum members,

    I have a vba situation where I need to know the address of the range that is currently being copied (or cut) ie: when Application.CutCopyMode <> 0 .

    I wonder if I am...
  4. Re: Opening multiple instances of Excel

    Have you tried setting : Excel Options |Advanced |Ignore other Applications thta use DDE
  5. Replies
    2
    Views
    43

    Re: Workbooks.Count problem

    Just a thought... Have you considered sinking the application events and listening to the _WorkbookOpen or _NewWorkbook application level events ?
  6. Re: 64 Bit 2016 Right Click Context Menu (User Form)

    The vba you posted is quite long and the userform has various controls in it so it is cumbersome to go through the entire code.

    If you can upload a copy of the workbook to some file shaing site...
  7. Re: Batch Script for New Versions and Shortcuts

    See if you can adapt this to you specific requirements
  8. Re: How to disable macro recording at a workbook level

    A cheap workaround that should immediatly abort the recording of macros while your workbook is open :

    In the ThisWorkbook Module:

    Option Explicit

    Private WithEvents cmbrs As CommandBars

    ...
  9. Re: How to disable macro recording at a workbook level

    How about Removing the Developper Tab or disabling the Record Macro control via xml for your specific workbook?
  10. Re: keyboard Shortcut for the ½ character

    Yes.

    When you set the ApplyToRange to say : "Sheet1!A1:G20", the loop should only be running when the active selection lies within that specific range.

    Once you select a range outside...
  11. Re: Get Cell Reference From Cell Address ?

    You are right.

    The cell reference resolves to a string in the end... I am trying to incorporate the INDIRECT(), ADDRESS() AND CELL("address") functions into a larger formula... I'll get back if I...
  12. Re: keyboard Shortcut for the ½ character

    The code runs a loop in the background while the selection lies within the ApplyToRange Range so that it can watch for the user key strokes... The loop stops only when getting out of that range.
    ...
  13. Re: keyboard Shortcut for the ½ character

    Happy it worked for you in the end and thank you for the feedback.
  14. Re: Run next lines of code while voice still playing

    Not knowing about the SpeechLib library, I don't think I can help any furhter.

    VBA can't do multithreading unless the code is executed inside a loaded dll.

    One possible workaround is to run the...
  15. Re: Run next lines of code while voice still playing

    Ok.

    Can you test this code that uses the Application.Speech Object with the SpeakAsync argument set to False and tell me if the MsgbOx shows While the voice is playing or After ?


    Option...
  16. Re: Get Cell Reference From Cell Address ?

    Thanks for the quick response FormR,

    The INDIRECT function takes a cell reference not a cell address.

    I need to pass a literal address string something like "B1".
  17. Get Cell Reference From Cell Address ?

    Hi dear forum members,

    Is there a formula that would take a cell address and return the corresponding cell reference so I can then use this reference as an argument in other fonctions such as...
  18. Re: Run next lines of code while voice still playing

    I have never use this speech library so I don't know if the following trick would work :

    If you place the code (MsgBox) inside a one-off windows timer callback function then the code might run...
  19. Re: keyboard Shortcut for the ½ character

    I followed the steps you described above: I unlocked the cell , then protected the worksheet but couldn't reproduce the issue you are experiencing.

    ctrl-space produces 1/2 just fine for me on...
  20. Re: getting columns to play sound when data is entered

    Enter the formula as an array formula with SHIFT+CTRL+ENTER
    {=IF(A2>0,SoundMe(),"")}
  21. Re: keyboard Shortcut for the ½ character

    Hi RincewindWIZZ

    I have revised the code and have fixed a couple of bugs .. Give this revised version a shot and let me know :

    workbook example
    (fixed version)


    1- Revised code in the...
  22. Re: keyboard Shortcut for the ½ character

    In the meantime, try closing the entire excel application and then reopen it and see if it works .
  23. Re: keyboard Shortcut for the ½ character

    Hi RincewindWIZZ,

    That is strange ... as per your description, you seem to have adapted the code to the name of your sheet correctly.

    Can you upload a test copy of your workbook to a file...
  24. Re: keyboard Shortcut for the ½ character

    Hi RincewindWIZZ


    Workbook example

    I have given this a shot resorting to the windows API and it seems to give good results.

    Basically, I have designed this OnKeyEx routine that works in a...
  25. Re: Application Quit closing down all instances of Excel

    How about closing the workbook only and not the whole application


    ThisWorkbook.Close False
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4