1. J

    how to fix an excel 2016 sheet with bad navigation

    CTRL + Shift + up and CTRL + Shift + dn only moves one row. I am using sticky keys & Win 10 on an Asus ROG gamer.
  2. I

    shortcut keys in macro

    Hello, Is there a way to create a list of all the shortcut keys I am already using in my personal xls file? Basically, I need a list off all my macros and their shortcut keys. Thanks,
  3. M

    Hot Keys for colors

    Hi, Is it possible to set custom hot keys for colors? For example, instead of Alt+H+H and then arrow keying to the color I want to select, is there a way to set Alt+H+H+1 to, say, white, and Alt+H+H+2 to black, Alt+H+H+3 to the third color in the palette, etc.? Thanks!
  4. Dr. Demento

    (Re-)assigning VBA Editor Shortcut Keys

    I understand how to assign shortcut keys in Excel, but I'm coming up blank on how to run a Sub while in the VBE using a shortcut key. Thanks y'all.
  5. G

    Shortcut keys for excel

    Hi I have tried to create shortcut keys in excel that is embedded in a word doc using macros. I have done it saving to personal macro workbook but when I g0 back into the word doc and double click into spreadsheet the macros I had previously recorded are not being recognized. What am I doing wrong?
  6. D

    Sorting a table with multiple columns

    Hello, I'm trying to sort 3 columns in a table that goes from A2-G192, but the code I came up with is not working. Not sure where I went wrong. Posting the code below, please let me know. Thank you, Private Sub Worksheet_Change(ByVal Target As Range)On Error Resume Next...
  7. M

    Excel VBA Scripting Dictionary Output Issue

    In VBA I have created a scripting dictionary called finDict that contains ~72k keys and items. I'm trying to write the list of keys to a worksheet. The code below correctly prints all of the keys in finDict, but it is extremely slow: For Z = 1 To finDict.Count...
  8. O

    Bypassing change event code if arrow keys are pressed.

    Hey all, I have a worksheet event code Private Sub Worksheet_SelectionChange(ByVal Target As Range) which works great. Well, I want to bypass or stop using it if a specific key is being held down. In this case the arrow keys. Reason being the arrow keys are used for scrolling through the...
  9. M

    Batch Script - Send Keys Inside of Batch Script to Excel?

    Is there a way to send keys inside of a batch script (.bat file) on Windows 10 to Excel 2016? For example, this link below provides an example on how to send keys in a batch script (.bat) to Word using the following commands: Link...
  10. A

    Is there a way to more quickly navigate the Fill Color and Font Color pickers using the keyboard, besides using the arrow keys, which takes awhile?

    Is there a way to more quickly navigate the Fill Color and Font Color pickers using the keyboard, besides using the arrow keys, which takes awhile? For example, it would be great to be able to jump from one end of the picker to another, both up/down and left/right. In case it's helpful, I'm...
  11. A

    Emulate "CTRL + F" in VBA to only FIND data

    I have been struggling for two days to find the answer to something which is probably simple to most Excel experts. I want to find data only (not replace) using code with a Next and Exit button (on the input box ??), pretty much like what the the CTRL +F keys do in Excel. The find information...
  12. R

    Query re static time entry

    I understand that a static time entry can be entered into a spreadsheet by using the [CTRL]+[SHIFT]+[SEMI COLON] keys. However, is there a way of doing this on an Android phone keyboard.
  13. E

    Find and delete windows registry key with specific value

    Hello, I am struggling for quite a while with a problem regarding the windows registry... I want to find and delete a registry key with a specific value in the registry folder: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Options The relevant registry keys are named "OPEN"...
  14. N

    VBA code to Record all keys pressed in window

    Hi all, Could you please provide me a macro that record all keys pressed in anywhere in system. It will also fine if it record all key pressed in Internet explorer only. Thanks, Nitesh
  15. R

    Open Excel without having any excel Opened

    I am researching currently if I can Open Excel without having any excel Opened. Is there something in Windows that can trigger excel opening, like can i press two keys together to get the excel opened which i want ? Not sure If this can be done:confused::confused::confused::confused:
  16. lopiteaux

    Case- and character sensitive match and count with VBA

    Hi, I need to compare 2 datasets, both with ~20k records, and determine whether a record in dataset A is present in dataset B. The keys I need to compare need to take into account: - case sensitivity (the keys are only unique when this distinction is made); - wildcards (the keys can contain *...
  17. L

    Listing all shortcut keys

    I have searched a lot for an answer to this and am beginning to think there isn't one... I would like to create a list of all the currently assigned shortcut keys, I don't just mean those assigned to macros but the ones delivered with Excel and that may or may not have been amended. I think...
  18. K

    Macros button assignments not working?

    Yesterday I changed my OS from Win7 to Win10, although not sure if that has anything to do with this issue in Excel... I have a series of macros which reside in my personal.xlsb file, that I have keys assigned to in my toolbars, that no longer work. If i hit these buttons I get the following...
  19. R

    Arrow Keys on Combo Box (Drop Down)

    Hey Friends, Hope all are doing well. I just made one drop down by using combo box. I want to select items by using up/down arrow keys. is it possible? please help Regards
  20. R

    Urgent Arrow Keys on Searchable DropDown

    Hello Everyone, I just made excel searchable drop down by using active x control (Combo Box) and it's working fine But to select the drop down value i have to use Mouse , however i want to select the drop down value by arrow keys. is it possible? Please help

Some videos you may like

This Week's Hot Topics