key

  1. D

    how do I make a macro run on any key press

    How do I get vba code to run if any key if pressed?
  2. G

    Key Word Search

    I am currently using a nested '=find(text,cell)' formula to categorise a list for example. If the term Doctor, Surgeon, Nurse, OT is in cell containing job title then the formula will return 'Medical'. This I have done by nesting separate find fictions for each key work with an if statement...
  3. A

    VBA for Highlighting Differences from 2 Sheets using Key Identifier

    I have 2 sheets (Sheet1 - New ; Sheet2 - Old) both sheets have a key identifier lets say in column B. I want to highlight the differences across each key identifier in sheet1 as compared to sheet2. If key identifier is new to Sheet1 - entire row should be highlighted Red. If there is any change...
  4. TAPS_MikeDion

    MS Excel for Mac 2011 - VB Ver 14.0 - Escape Key capture

    Hi all, Does anyone know if VB key capture works with Excel for Mac 2011? I have tried several different methods to capture the ESC key being pressed and I can't seem to get it to do anything. The last simple thing I tried was: Application.OnKey "{ESC}", "EscapeKeyPressed" inside the...
  5. S

    Set a shortcut key for "Copy Format"

    Hi, Is there a way to set a shortcut key for "Copy Format" ? Or use VBA to imitate the usual mouse-click / mouse-double-click function of "Copy Format" Thanks a lot!
  6. L

    saveas workbook in vba - default location

    Hi I have saved a file in usb key. I opened the file from usb key. I ran the code below. I entered a new name, hello. The file was saved in C: drive under Documents, not in the usb key where the file originally was opened from! Why is that? Thank you very much Sub saveas_wb() Dim x As...
  7. S

    Sum from sheets name based on another cell valu

    Hi I have Key & sheet names in Sheet1 & key(with Concatenate) need to vlookup with Key in another sheets & get the Sheet Name & sum the column values.
  8. G

    How do I run a macro every time key pressed

    Hi I found this macro on here that runs a macro when the delete key is pressed on book opening. What I’m trying to do if poss is to have this but to be able to have it numerous times. I.E click on delete key run macro then push delete key run another macro and so on.... Can I do this...
  9. kelly mort

    VBA code to detect mouse movement run a certain code.

    I have a sub that I won't to run anything there is a mouse movement or a key is pressed. It's the stopTimer Sub I found on the web somewhere. So I have this voice code a run periodically. So when I move the move or press a key, then I will like to call the "stiptimer" sub. I will be...
  10. B

    Offset

    Good Afternoon Could someone explain (May be missing something) why the print to worksheet is in Column E <colgroup><col width="83" style="width: 62pt;"> <tbody> Sub SplitColA() Dim i& Dim Cola() As Variant Dim dict As Variant Set dict =...
  11. BlakeSkate

    Comparing DICtionaries ( ͡° ͜ʖ ͡°)

    So i'm trying to check if a key from one dictionary exists in another, and if it does to write the value/keys to sheets depending on some if statements Loop through all the keys from dicLIVE if that key exists in dicQTY, the key contains "^4", and and the dicQTY value is greater than 8 then...
  12. M

    Prevent Selection Change

    Hi I want to prevent the SelectionChange procedure from running if the user pressed the TAB or RETURN key to get to the cell. How do I check for the last key pressed ? Thank you in advance. Al
  13. T

    Reducing a Selection by one cell.

    Hello, Today is just one of those days that Excel just keeps beating my butt. After an hour of trying to write a simple three line code and getting nowhere I have come to the experts. The background is that I have a string in cell A10, ten blank cells (going down the column), and then a...
  14. L

    return value if cell contains specific text

    Hi, I am trying to automate a way of searching through my bank statement and returning a reference number based on the narrative that appears on the statement (sample data attached). We get hundreds of items every day and the narrative that is quoted on the bank statement is always different...
  15. E

    Convert .txt single column list to Excel table

    Hi, I have below list (qty >20000 lines) in .txt format: Task list ABCDEF1 Operation 0010 ABCDEF1 Work center PP Control key ZM01 Number of persons 1 Work 1.0 HR Duration 1.0 HR Task list ABCDEF2 Operation 0010 ABCDEF2 Work center QQ Control key ZM01 Number of persons 1 Work 2.0 HR Duration...
  16. J

    Derive relationships based on data

    Hi all, I have a database - about databases - so what it does is stores all information about the various databases that we run, table names, columns that are linked column sizes, descriptions etc. I have a System table that links to a MasterTable (table) and then a column table. The column...
  17. D

    VBA transfer data in specific cells to table (based on conditions)

    Hello everyone, I need your help with writing a VBA-script to automate a daily work. Every day I receive multiple data entry sheets (Excel) by mail. I have to extract the data in the sheets to a table in another workbook stored on my drive. All sheets have the same format, which means the data...
  18. M

    ERRORS in VBA FUnctions "InputBox" & "Select Case"

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

    Detect Mouse Click and Keyboard key

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

    VBA rounding before Sumproduct (with named column range)

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

Some videos you may like

This Week's Hot Topics

  • Get External Data (long shot question!)
    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to...
  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • Cell Formatting
    Good Morning, I need to format a few different cells in the following manners: A1 has to always add a colon (:) after whatever is typed in by a...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • Workbook_Change stopped working !
    I am working on an app to speed up & automate processing of Credit Cards statements. After data is input from a CSV file, it is presented to the...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
Top