triggered

  1. mumps

    Macro slows down with each use

    I have a Worksheet_SelectionChange event that runs very quickly the first time it is triggered after the file is opened. Selecting a cell brings up a calendar and upon selecting a date in the calendar, some data is processed. Each successive time the macro is triggered, it slows down even...
  2. Jerry Sullivan

    VBA anomaly when filtering table from Worksheet_Calculate

    When the user filters Table1, my objective is to have Table2 on the same sheet filtered so that both tables have the same ID items visible. Since VBA doesn't have an event that is triggered when a table is filtered, I'm using the Worksheet_Calculate event which is triggered due to the presence...
  3. A

    VBA Script fails when triggered by Worksheet_Activate()

    Hi All, Quite embarrassed with this one but can't for the life of me fix it. I have a VBA script that works perfectly when triggered as a Macro, but fails when triggered by Worksheet_Activate. The line that fails is: dest.Range("A6:M1000").AutoFilter Field:=pn.Column, Criteria1:="" Where...
  4. L

    Worksheet_SelectionChange won't work with Protected Sheet

    The event is triggered just fine when the worksheet is not protected. When I protect it, however, this event is no longer being triggered. Nothing else has changed. Is this how Excel is supposed to work? Not sure if I'm missing something here...
  5. N

    Specific change using Worksheet_Change

    Hi all, I would like to know how to make excel play a sound when a specific change occurs. For example, I have a range of cells (F6 to F50) with formula within the cells. They are blank at first (which is normal). When the stock market moves, some of the cells (say F8 and F25) are "Triggered"...
  6. H

    Formatting of cells to allow spill over to next cell containing a formula

    Hi all, I hope someone can help or point me in the wright direction. I have a book which I'm building and one of the sheets contains the out comes of the user input, so the formulas on this page are =IF(AND(....=IF(OR... etc and there are a lot of them! So I thought I could place quite a few...
  7. A

    Combobox show dropdown list

    How van i show the content of dropdown list when triggered?.thanks for the response
  8. I

    Want to contents of cell to be email body - Please Help

    Exactly as the title says. I have a macro that checks to see if a condition is met in a range of cells, and then sends an email. I want to go one step further and have the contents of the cell to the left of the cell that triggered the macro to be part of my email body. Can anyone help. I am a...

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 MrExcel.com.
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 "mrexcel.com".
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
Back
Top