trigger

Hi, I am using this VBA script to get some sorting done. But my cells reference formulas on other sheets that do not trigger it as the cell changing - hope that makes sense. Can I nest and Else if to look at the other sheets to trigger the changes? Working... Private Sub...

I've created a formula by concatenating multiple cells which each contains pieces of the overall formula. Once I have the full formula concatenated in a cell I do a copy paste special - VALUE so it will create the text of the formula and eliminate the concatenate function. Once I get to this...

I am trying to write some code which cycles through a single worksheet looking for trigger words, then copy and paste a range of data to the end of the sheet. I have searched the whole of the internet, and this isn't really covered. I have tried to Frankenstein some coding, but my skills are a...

Hi, I am trying to automate a particular process where when I receive an email with a particular attachment I open the email, run a macro and close the spreadsheet. (The macro migrates data to a record sheet, generates an email and sends a 3rd spreadsheet on to a predefined distribution list...

Hi All, This community has been a big help after my first post, and now I need some assistance with a function I've been trying to solve (I'm losing hair). I have a sheet with a few tabs, 'MMenu,' and 'Calendar,' and a macro called 'Fourfivedays.' I want this this macro to trigger in...

Hi, I am trying to create a formula, that when the trigger in column C is met (1 being trigger met), takes the cash going forward in column A to column D, until the point that the sum of the cash in column D equals % of the cumulative cash at the trigger point. For example, the trigger hits...

Hello, I'm not familiar with the coding world very much. I have just one main requirement for my project. Detect F10 key release/up and trigger the following two key combinations in the sequence given below. 1) Shift+Home 2) Ctrl+C I really hope it can be done. Thank you and will...

Hi everyone, i'm trying to trigger some code when a table gets new rows. For example, for my financial records, i periodically check for new transactions on my bank website, and copy them and append them into an excel table. When I do this, i want to input the date into a cell to know when i...

Is it possible to trigger macro from outside excel environment? My requirement is to take screenshot of citrix application when we click on it.

Please help with VBA once A1 is changed to value of 1 then trigger the file to save and close itself. Thanks

Good Day to you all. Please be advised that I have a situation whereby I need to be able to add 5% to a cell value, and control the total by adding a 'y' in a box to trigger the calculation. For example - <colgroup><col width="64" style="width: 48pt;" span="4"> <tbody> Volume +5% Plus...

I have created an alarm like if the time = to current time then it will fire the send email. Its working properly. My only problem is the loop.. example alarm 1 = 1:00 PM alarm 2= 1:15 PM alarm 3= 1:30 PM if alarm 1 is trigger excel will send email... now if the alarm 2 is trigger excel will...

I have created an alarm like if the time = to current time then it will fire the send email. Its working properly. My only problem is the loop.. example alarm 1 = 1:00 PM alarm 2= 1:15 PM alarm 3= 1:30 PM if alarm 1 is trigger excel send email... now is the alarm 2 is trigger excel will send...

Hello Friends I have 2 workbooks named as N1 and M1 .. M1 workbook just has some data in A9 to A24 thats all no code nothing, Now I copied the Data and pasted it as a link on N1 workbook in A column I have a formula in Column D9:D24 which returns "Yes" or "No" when a criteria is met. I have a...

Dear Experts, I'd like to run macros on a Web page but as far as I know this is not possible or quite difficult. So I want to at least imitate it. My idea: create a userform, show a Web page on it then detect if e.g. a button was clicked on that Web page on the userform. Then run a macro after...

Hi guys, I've been searching on web to find a solution to my problem but have only found variations so far. So I need excel to automatically send an email when a cell in column X changes from "Y" to "N". In that email I need the corresponding row only be copied into the email. So say cell X3...

Hello expoerts, I have a sheet whereby when 1 cell in column T is filled with a valid date, then that row in the sheet will be moved to a different sheet. Problem is: when I perform the cut/paste, that is also seen as an alteration to the column T, starts subroutine of the cell change, and the...

Hello, I am trying to come up with a macro that will make a change to one workbook based on another workbook opening. basically something to the extent of this: If workbook 'Master' opens, then change the color of cell A1 on 'sheet1' in workbook 'Tables'. The scope of this project is as...

Hello all, I have a worksheet that autorefreshes every five minutes. I also have a macro that reformats the range of a chart based on the value of a given cell D1. The value of D1 may change after the autorefresh. I'm very very new to VBA so please bear with me. I tried one bit of code (see...

Hello, im trying to trigger a macro from a barcode example: im scanning bar codes cell1: SWGH cell2: SUIE cell3: ABYT cell4: NEXT<------ this imput triggers a MACRO called newsheet() is it possible? Thanks in advance.