+ Reply to Thread
Results 1 to 3 of 3

Can I Select VbOKonly message box with keyboard

  1. #1
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Can I Select VbOKonly message box with keyboard

    I was creating a filter and print macro but I had left message box alerts to check ranges etc in the code

    Unfortunately the last of these message boxes has appeared BEHIND the modal userform the print option is initialised from

    Is there any way to either select OK with keyboard or stop the code as If I Ctrl Alt Del I will lose a hour or so of work (I Know Lol-Save as you go along)

    Any pointers appreciated

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Can I Select VbOKonly message box with keyboard

    Hi,

    I assume you have tried Enter or Esc?
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Expert nigelog's Avatar
    Join Date
    12-14-2007
    Location
    Cork, Ireland
    MS-Off Ver
    Office 365 Windows 10
    Posts
    2,286

    Re: Can I Select VbOKonly message box with keyboard

    All ... tab enter full keyboard access etc. I ctrl Alt Deleted and started again. Not as bad as I thought...Ta for suggestion

+ 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. Keyboard shortcut to select embedded chart
    By MrShorty in forum Excel General
    Replies: 5
    Last Post: 01-08-2016, 06:23 PM
  2. [SOLVED] Formula Autocomplete - How to select via keyboard?
    By gsjan1 in forum Excel General
    Replies: 4
    Last Post: 07-02-2012, 12:05 PM
  3. Paste Clipboard on vbOKOnly
    By Ada01 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-03-2009, 01:17 PM
  4. keyboard select question
    By khaos in forum Excel General
    Replies: 3
    Last Post: 04-23-2007, 02:34 PM
  5. USE KEYBOARD TO SELECT ALL SHEETS
    By enos newt gribble in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-22-2006, 03:55 PM
  6. Listbox Select items with Keyboard.
    By Casey in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-17-2006, 03:26 PM
  7. Select Worksheets With Keyboard
    By Lewis Clark in forum Excel General
    Replies: 3
    Last Post: 02-20-2006, 05:45 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