1. G

    Is there a way to call array member by key instead of index?

    I have been using an awkward method to store and call my UDT arrays by key. That is by making an array and corresponding collection for storing the array index and calling the content by key, please see my code below. Is there better practice for this in VBA? That maybe can call array member by...
  2. I

    Nested For Each Statement: Identifying Key words from Range within a Range

    Dear Mr Excel I would be so grateful for some help with this. I have 4 Sheets that contain data that i am trying to write a code for. MessagesSheet (Which is named "replies" followed by "date" and "time"): This contains text messages received. The data is organised as follows: Each row...
  3. I

    How to edit this copy and paste VBA code to include duplicate values?

    Hello. So I have two workbooks here. I have attached screenshots of both. One is Pickorder. Column A lists the dispatch times. Column B has route codes. Column D has the dispatch areas. Column E has the dsp taking the route. For example, CX19 dispatches at 6:15:00, at STG.A01 for HIQL. I then...
  4. 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?
  5. 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...
  6. 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...
  7. 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...
  8. 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!
  9. 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...
  10. 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.
  11. 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...
  12. 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...
  13. B


    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 =...
  14. DataBlake

    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...
  15. 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
  16. 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...
  17. 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...
  18. 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...
  19. 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...
  20. 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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back