Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.25 seconds.

  1. 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...
  2. 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...
  3. 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.
    ...
  4. Re: keyboard Shortcut for the ½ character

    Happy it worked for you in the end and thank you for the feedback.
  5. 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...
  6. 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...
  7. 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".
  8. 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...
  9. 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...
  10. 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...
  11. 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(),"")}
  12. 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...
  13. Re: keyboard Shortcut for the ½ character

    In the meantime, try closing the entire excel application and then reopen it and see if it works .
  14. 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...
  15. 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...
  16. Re: Application Quit closing down all instances of Excel

    How about closing the workbook only and not the whole application


    ThisWorkbook.Close False
  17. Re: Resume macro to next line when get Prompt

    I have given the windows cbt hook approach a shot but before we take this any further, did you try setting the Excel DisplayAletrs Property to False before running the code ?

    Like This :

    Sub...
  18. Re: Resume macro to next line when get Prompt

    Hi SmarterLife,

    The only other thing that I can think of is to install a WH_CBT hook or have a windows timer routine to detect the moent the prompt comes up and send a message to it in order to...
  19. Replies
    10
    Views
    143

    Re: Concatenate & Remove Duplicate

    Ok- Thanks .
  20. Replies
    10
    Views
    143

    Re: Concatenate & Remove Duplicate

    Hi Fluff,

    Do you know which version of excel first introduced the RemoveDuplicates functionality\Method ?

    Regards.
  21. Re: Resume macro to next line when get Prompt

    I have successfully used the CoRegisterMessageFilter API in the past to prevent excel from getting locked when waiting for a response from another ole server such as from a second instance of excel...
  22. Re: Excel VBA How to Coply excel columns into NotePad

    Here is a much bulletproof method that takes into account the possible scenario where there are more than on Notepad window opened .


    Option Explicit

    #If VBA7 Then
    Private Declare...
  23. Re: Excel VBA How to Coply excel columns into NotePad

    I woudn't use SendKeys as it doesn't work consistently and depends on focus plus it turns off the keyboard Numeric pad.

    A more reilable way is by using the Sendmessage API :

    Option Explicit
    ...
  24. Re: Customised Ribbon using Custom UI editor for Microsoft Office

    Good!

    I hope the code also works in versions 2007,2010 and 2019.
  25. Re: Customised Ribbon using Custom UI editor for Microsoft Office

    Glad you got this working.

    Can I ask which version of office you are using ?

    Regards.
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4