1. brendalpzm

    Gather Microsoft Bookings in an online excel located in sharepoint with power automate

    I'm creating a booking page with micrsoft bookings and I'd like to gather all the bookings in an excel file like a table or something, I don't know if it might be better in dataverse? I'm not sure. The file that can be exported from microsoft bookings is an tsv file
  2. N

    Triggering a HTTP Search, through Cell Value Alteration

    Hi everyone, I have another question for everyone. This one is a bit complicated as several aspects of the code need fixing, and I am having a hard time doing so. If there are any helpful mind out there please have a look at he the problem below. What the VBA code should do: Each time text is...
  3. X

    Code triggers if someone opens a specific workbook

    Heya, how do you trigger the code on how to see if someone opens a vba on that workbook?
  4. M

    Trigger event between dates

    Hi, I'm wanting to trigger an event between certain dates. I have a named range called "Licence" on the sheet named "Lists". Within "licence is a date. For the full week before this date is met I want a message box to open, after the date I want the code to be bypassed. I was trying to use...
  5. L

    Worksheet trigger works one-time

    Hi all, I'm trying to use worksheet triggers to run a macro but it only works one time and then never again. Example: If write a worksheet trigger to hide rows if a cell displays 'Yes' (list data validation), it will work the first time after the workbook was open. After it has worked that one...
  6. C

    Trigger macro if range contains

    Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("A12")) Is Nothing Then If Range("A12").Value = "Bin1" Then Call ‘my macro’ End If End Sub Hi I have the above code that triggers ‘my macro’ when the text ‘Bin1’ is entered into cell A12, and it works fine...
  7. J

    Looping through Data

    Hi: I have data in col A and B. I'd like to build a macro that, if it finds the term "trigger" in col A, it copies the data in col B to col C (all in the same row). But, if it doesn't find the term "trigger" in col A, it copies the prior successful data to col C. Here's what I have so far ...
  8. B

    VBA question sending email

    Hello, NewMember here…. I have twocolumns AA7:AB70 that will display the word “Warning” after cell in column F7:F70becomes greater than zero. I am lookingto be able to trigger an email with the row and column reference when this happens. Is thispossible? Not a vba person! Thanks foryour...
  9. A

    Comment with scroll bar

    Can I create a comment template with a scroll bar using VBA which gets trigger through a command button
  10. W

    need to "read" value not formula

    Hi! Would really appreciate some help on this. I have a sheet (sheet1) with the cell «AB6» This Cell has a quite big formula to calculate values from multiple sheets and it works great. I have a macro to trigger if the cell value of AB6 =1 This macro is a “Private Sub Worksheet_Change(ByVal...
  11. W

    change trigger from Worksheet_Change to Woorksheet_Calaculate

    I'm trying to change the trigger from Worksheet_Change to worksheet_calculate cannot get it to work. Private Sub Worksheet_Change(ByVal target As Range) If target.Cells.Count <> 1 Then Exit Sub If target.Address <> "F13" Then Exit Sub If (target.Value >= 0) And (target.Value < 0) ThenExit...
  12. A

    Trigger event based on local maxima and minima

    Hi, I want to trigger an event based on two conditions: at a fixed percentage of a data value of a local maxima, after a local maxima occurs in the data, to turn the event on. Alternatively, at fixed a percentage of the data value where a local minima occurs, to turn the event off. Data values...
  13. F

    IF forumla for fortnightly and monthly reminders

    I have this spreadsheet that I am trying to create for payroll reminders for weekly, fortnightly and monthly clients. With the Weekly pay clients I need to trigger every Tuesday to be highlighted. With the fortnightly clients I need to trigger every second Tuesday and for the monthly clients I...
  14. I

    Formula for auto notification email send by expired date trigger on cell value

    Dear Expert, I would like to create a notification email send automatically which trigger by expired date input on cell for excel 2010. Kindly sharing your formula for allow me to learn from you. Thanks.
  15. A

    trigger textbox change event

    I'm using the code below to fill a textbox with a number and triggers a change event once filled. However, if the number is the same on the next row, it does not trigger the change event. How can I trigger the change event if the number is the same? tbOQty = Range("F" & ActiveCell.Row)
  16. D

    Use mouse back as trigger for macro/ribbon button

    Hi, I have a ribbon button that allows switching between the last 2 selected sheets. Is there any way to use the mouse back button as a trigger for this ribbon button, or directly for the macro? This would make it much more user friendly. Kind regards, Daniel
  17. W

    Add row to table based on second to last row

    Hi friends, I want to add a new row to my table "Time_log" based on if there is any content in the second to last row of the table (the very last row is my "totals" row). I want this to trigger whenever someone adds content to the second to last row, so that it make a new row available for more...
  18. B

    In VBA, trigger a sub when a cell gets the focus

    I want to be able to trigger a subroutine when I click on a certain cell. Presumably clicking on any cell would trigger the sub; but I can put code in the sub to determine if the selected cell meets my criteria for action, and if yes, what that action should be. So far I haven't figured out how...
  19. M

    Triggering Refedit change event

    I'm using 3 refedit controls in a form and for some reason I can't figure out how to get it to trigger an event when the value of the control is changed. What I'd like to do is make it trigger an event so that when someone clicks onto the worksheet to change the range, it would cause the focus...
  20. C

    Vlookup Column in another sheet

    Hello. I have a Table where i have values in Column A. And i want to lookup dat value in sheet2, and replace it and the same column. All of this with the trigger of a button. I have stumbled around many codes, but none of them seems to fit my purpose. Explained <tbody> Button Trigger...

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