+ Reply to Thread
Results 1 to 4 of 4

Pressing F3 key to trigger message box

  1. #1
    Registered User
    Join Date
    05-08-2017
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    81

    Pressing F3 key to trigger message box

    Hi,

    I want to display a simple message box when the user presses F3. I've looked online but for the life of me, I'm not able to get a simple key press to work.

    I have the following code:

    Please Login or Register  to view this content.
    If I run it, it works. How would I get it to run if F3 was pressed?

    Thanks!
    Last edited by noname91; 03-27-2020 at 03:59 PM.

  2. #2
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Pressing F3 key to trigger message box

    It seems you do not managed correctly code tags: [/ must go just before the last CODE word

    In a module put next code

    Please Login or Register  to view this content.
    - Battle without fear gives no glory - Just try

  3. #3
    Registered User
    Join Date
    05-08-2017
    Location
    Toronto
    MS-Off Ver
    2016
    Posts
    81

    Re: Pressing F3 key to trigger message box

    Thank you PCI. Works as expected.

  4. #4
    Forum Expert
    Join Date
    12-24-2007
    Location
    Alsace - France
    MS-Off Ver
    MS 365 Office Suite
    Posts
    5,066

    Re: Pressing F3 key to trigger message box

    You're welcome and Thx for the Rep.
    Enjoy Excel.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Debug message / trigger and stop macro.
    By CH81 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-15-2019, 09:05 PM
  2. Trigger message box after user updates VBA form based on data calculated in a cell
    By blackelvis73 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-15-2016, 12:51 PM
  3. Adjust a code from cell range trigger to button trigger
    By ld2x07 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-01-2014, 10:02 AM
  4. How to trigger desktop message box or e-mail for a date alert
    By sarahw2000 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-14-2014, 06:13 AM
  5. Message box VBA - trigger to remain constant, need VBA to stop thereafter
    By orlando212 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-31-2013, 08:55 AM
  6. Trigger macro when entering text in a cell, without pressing enter
    By DGagnon in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-06-2012, 05:53 PM
  7. how to require pwd as pressing Alt+F11 ?
    By vumian in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2006, 01:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1