key

These 2 VBA expressions do not function as it the are documented to, and I found that these had been recently implimented and broke code I've been running for years. INPUTBOX The docmentation says that if you hit the "Cancel" key that the routine returns a FALSE. It now returns an Empty String...

Assuming I have two codes, how can I wrap my code to detect if Enter key was pressed or a mouse click? So, if it is enter key it should run one code, if mouse click it should run another code

Hi guys I have data in 2 named column range (real data was 81 column & growing 60.000++ row data) name "key" in range column A:A (string) name "value" in range column B:B (decimal) data example: key, value A, 10,212 A, 12,990 B, 11,119 B, 9,888 C, 2,911 i want to round every value first...

Is it possible in VBA to detect a system wide key or mouse movement? I need to trigger an *action* when any key or mouse movement is detected system (Windows) wide

I have a worksheet I am trying to create a filter for. I recorded a macro with all of the filtering set to what I need. When I try to assign it to my ComboBox and run it I am getting a Run-Time Error 91 Object variable or with block variable not set. It is highlighting the section "...

I need a Function when i Open My workbook with Lots of Sheet's Controlling Game of Dart's (Round Robin and Cup system by Draw and Seed's Of player... The function i need is "if file with key in Specific Libary Exits then Open" Workbook if file not exist Type "masterCode" to open Workbook...

I have some coding below that provides a "license key" of sorts for the workbook. While writing it, I've messed something up (that's probably obvious) because each time I open the test workbook, it asks me for the license key. The "expirationdate" is a specified cell with an end date set 360...

Hi I have a sheet containing a member reference (treated as a primary key) in column A and a bunch of data in columns B to CI. When I filter the sheet to, say, 100 of the 1000 rows, and use the Control+F Find function, it won't find a primary key, even if that key is displaying within the...

I am having a bit of an issue trying to get the sendkey to work with a function key. works great with some functions like home and even tab, enter etc. I just can not get it to hit the F2 key. everything I see says to use {F2} but the {} do not work for me, I found success in the []. this works...

Hello to all! Hope you can help me. I have an issue in an excel file that i want to disable 'enter' so users can navigate in excel sheets with arrows only. is there a simple way to de-activate the enter key only for the specific excel file (lets call it test.xlsx thanks!! Andreas

Hello all, Stuck on a code where I need to find key word and from that key word copy all rows below it. I keep getting Method 'Range' of Oject' _ Global Failed error Header2 = Kps.Cells(5, 2) MtTabs = Cells(Rows.Count, 1).End(xlUp).Row For q = 6 To MtTabs MAITName = Kps.Cells(q, 1) Family =...

Hello All, This is my first post and I really hope someone can be of help. I normally try and eek out success with Excel but this has got me stumped. Everything I find seems to just fall to the side of what I need to do. Here is a quick example. Let's say I have Sheet 1 that has this data...

Hi, I have data in > 2,500 CSV files to aggregate, clean and reduce to 2 columns. Each file contains at mininum an address and restricted key word e.g. 1 Abbey Road, License Submitted (key word in bold) Some files have more than 1 address and key word, e.g. 1 Abbey Road, License Submitted, 2...

I've got a tough one, been racking my brains on this for a bit. In short I'm trying to create a "hierarchy" key based on everyone above an individual. For example if I'm four levels down from the CEO, my hierarchy key will be my id, my bosses id, his bosses id, and the CEO. The CEO doesn't have...

I've been looking for some time for code to perform the simple operation of flipping numbers back and forth between positive and negative. As an accountant I've tried many, many versions. Some work quickly, but balk when it interacts with text - error #Value . Others are super slow as it...

So I got a new computer and on it came Office/Excel 365. I pulled open one of the spreadsheets that I have been working on and figured out that the "-" key doesn't work when it is the first key pushed in a cell. For example: If I want to put in a negative number I would input -123, the...

Hey excel gurus, I would need your help on running a specific code when key state is up. I am already aware of a OnKey method but that is not what I require. Another way of achieving this would be to use AutoHotKey. With a hotkey assigned to the excel macro that gets triggered on key up state...

Hey, Hope all is fine. I would like to learn from you, how would I remap my Enter key to a Down arrow key? I tried a script but it does not work. Application.OnKey "{Enter}", "{DOWN}" Will appreciate. Thank u.

Hello all I hope you can help on this please Sheet1 has a unique key in column "L" Sheet1 also has a status in column "H" with options of "A" or "C" Sheet2 has the same unique key in Column "J" What I want to do is starting from Row 7 Sheet1 = If "H" = "A" then copy this row to sheet2 but...

Hi to all of you, it would be highly appreciate to advice me how to format from cell A4 till rows down (all rows down), so that to valid only date in format dd/mm/yyyy and also should be key cells so that, if i do not enter the date, should not work in any other cell. Thank you all in advance