keys

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

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,

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!

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.

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?

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...

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...

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...

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...

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...

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...

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.

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"...

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

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:

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 *...

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...

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...

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

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