none
Select cell continue RRS feed

  • Question

  • I am looking for a click cell selector.

    using x=InputBox("X") requires a second keypress for OK or Cancel

    I am want to click the mouse on a cell and either make that the active cell or return the cell contents (WITHOUT having to press ENTER or Cancel) and then continue running the macro

    I am looking to (single or double) click on a cell and return either the row of the click or the contents of the clicked cell.

    Saturday, February 24, 2018 12:49 AM

All replies

  • Hello bmg100,

    >>I am want to click the mouse on a cell and either make that the active cell or return the cell contents (WITHOUT having to press ENTER or Cancel) and then continue running the macro

    As far as I know, Excel Object Model does not provide such function. We have to press OK or Cancel to close the input box to make code continue to run.

    Best Regards,

    Terry


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Saturday, February 24, 2018 5:26 AM