Detect Mouse Click and Keyboard key

[yinkajewole]

Assuming I have two codes, how can I wrap my code to detect if Enter key was pressed or a mouse click? So, if it is enter key it should run one code, if mouse click it should run another code

 

[DataBlake]

So, if it is enter key it should run one code, if mouse click it should run another code

where are they clicking (on a sheet? on a userform? a command button?), and where is the activecell upon pressing enter?
Do you want these codes to run every single time someone clicks or presses enter?
please also include sheet names where applicable

 

[DataBlake]

but as a general answer you can use "application.onkey" in a worksheet sub where you activate the sheet and press enter anywhere on the sheet and then when you leave the sheet these codes deactivate so that you have normal functionality of enter.

so lets say you copy this into sheet1's VBA module

<code>Private Sub Worksheet_Activate()
    Application.OnKey "{ENTER}", "ACode"
End Sub

</code><code><code>Private Sub Worksheet_Deactivate()
    </code></code><code><code><code>Application.OnKey "{ENTER}", ""</code>
End Sub</code></code>

That will use the numeric enter key to execute a procedure
and below is the regular enter key to execute a procedure

<code>Private Sub Worksheet_Activate()
    Application.OnKey "~", "ACode"
End Sub

</code><code><code>Private Sub Worksheet_Deactivate()
    </code></code><code><code><code>Application.OnKey "~", ""</code>
End Sub</code></code>

clicking is a different sheet specific code as well
but i would like more details before i really get into it.