key

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

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

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

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

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

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

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

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!

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

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.

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

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

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

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

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

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

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

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

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

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