shortcut

I know keyboard shortcuts can be set when recording a macro. Is is possible to insert one into an existing macro? So far I've created a simple macro then added code to it thinking this would work. Nope! I got "this will reset project" which looks to wipe out the shortcut. I've also looked...

Hi, I'm looking for a shortcut to change a date in a cell to the next day. So for instance; i have a cell with 01/Jan/2017 and I want to change the date in that cell to 02/Jan/2017 (not the cell underneath - I know about the drag function which will copy or increase the date in cells...

I already have the code in workbook module, but I have assigned it to a keyboard shortcut (Ctrl+d) and that works in all of the sheets in that workbook. What's the recommended way to restrict the macro so that it only runs when called from one sheet? Can I restrict the shortcut to just one...

In the macro naming window, there is an option to create a shortcut to run the macro. But there is only one modifier key option (Ctrl) with an empty field for the character to complete the combination. Why is there only one modifier option and how do I know that the character I choose isn't...

I recently changed companies and couldn't take my Addin with me, but in my previous Addin, I had nearly every letter on the keyboard associated with a CNTRL+SHFT+<Shortcut Key>. I've rebuilt the most important of the shortcut keys and obviously, having used them thousands of times, it was easy...

At my work we run off a networked system. The only way I can make my excel tool to be used by my fellow counterparts is by creating a shortcut from the network drive to my desktop, than save the workbook by using that path. What is a way that i can save my workbook to this shortcutted folder.

Hi Guys!, Can i get some help from you all and know some excel shortcut for my formula? This following is my formula: so basically what i want is that if the value of cell L2 is =s to any cell of column D (eg, L2 = D15) then it would be equals to the row of D but column of H Thank you all very...

I am building some shortcuts into excel and am wondering how do I make a keyboard shortcut that can toggle between different formats. I would like to create several toggles highlighted below and hopefully more thereafter: - Toggle Between Colors with “Cntrl + Shift + C” (Blue, Green, Red) -...

I have several, probably more than 10 shortcut keys assigned to my macros. I know I can open each macro and check options to see which key I have assigned, but is there a property in VBE that will tell me which, if any, shortcut key I assigned to a macro? Or is there any handy code that someone...

Hi all, I am trying to open a SAS.EXE application through a .lnk file (i.e. a shortcut). The code I have so far is as follows First bit declares a new function: Public Declare Function ShellExecute _ Lib "shell32.dll" _ Alias "ShellExecuteA" ( _ ByVal hwnd As Long, _ ByVal lpOperation As...

I'm trying to have a FileDialog select a shortcut (*.lnk) file, and not the destination file in VBA. E.g. 'C:\MyShortcut.lnk' is a shortcut to 'C:\SomeFolder\BurriedDeep\MyFile.xls' and I want to select the shortcut and update it to 'C:\SomeFolder\BurriedDeep\MyNewFile.xls' MSDN link about...

Im trying to copy a cell formula down from say, O2 down to O161886 where my data actually ends. But when I attempt the common Ctrl+End, it actually goes to the end of nowhere nowhere (about the millionth row) instead of where physical data ends. What Shortcut Keys or methods are used in...

Hello, :smile: So the problem is, I am creating a simple game in Excel&VBA with two players, each player needs to control four keys. For the first player, I used the four direction keys and Application.OnKey function, like this: Sub DeclareKeys() Application.OnKey "{UP}", "Move_up"...

Hello guys, here are my specs: Lenovo laptop with WIN7 64 Bit Office 365 Home English Slovak Keyboard Layout (so I have to press "shift" key in order to type a number; otherwise if I press "1" i get "+" sign, if I press "2", I get "ľ" sign and so on) here is my problem: When I want to use...

Hi Experts, I am looking for a shortcut key (if possible) to remove full row in excel. Basically I have a huge list with: Company Name - First Name - Last Name - Email Address What I am doing is Going through each row and when there is a Email which match company name instead of first and last...

Hi all, Could anyone please remind me of how I can select my current line / fill to the right only to the end of the line above? I.e. I have figures in the line above the blank line I'm currently in and I'd like to copy a formula all the way across to the right. But not as far as the whole...

In Excel 2010, when I use Control F shortcut it goes to a cell and puts in an #NAME? error in two cells. For example, on a blank worksheet in cell A1, when I use Control F, it goes to cells Q2 and R2 and displays #NAME?. In the information bar, Q2 says "=Client" and R2 says "=NoPart". Any...

Hello friendly helping people, Currently I am working in a German Excel, and thus the shortcuts are all confused. Howered, I need to restore the Ctrl+V shortcut for filling values in a column, because I need it badly :) I have tried to record a macro and save it to my personal.xlsb, but it...

Does anyone know if it is possible to change the Alt Hotkeys that select different tabs/add-ins on the ribbon bar? I have several add-ins that I am required to use at work, and I would prefer that their Alt Hotkeys weren't randomly chosen. For example, my FactSet add-in uses "S1" which is...

Hi There. I have created an auto correct entry for entering degree C and degree F where degree is actually the degree symbol oof for degree F and ooc for degree C). But in order for it to work, it has to be a separate word. So I end up entering 20 oof and there is a space between 20 and the...