worksheet_change trigger

  1. M

    Worksheet_change Error 91

    First time writing worksheet_change code and I have gotten 2 codes to work, but I cannot get them to work together. The first piece of code is just to hide and unhide tabs, and it works until I paste the second piece of code which is to replace cell values when entered into a specific range...
  2. Sandcastor

    Worksheet_Change to target two specific cells

    I require a little help streamlining a Worksheet_Change event to target only two cells. In info sheet requires my technicians entering the date their meters were last calibrated, and pops up a warning dialogue (which works just fine) when the meters are due to be calibrated, or overdue. The...
  3. E

    Worksheet_change acting on new active cell instead of original

    Hi, I have written a macro that automatically assigns the next available project number once a new project title is entered. It works great if I type in the new title and press Enter. However, if I tab over to the next cell instead, it puts the new project number in the wrong cell (1 cell...
  4. X

    Operation that triggered Change event & call-iteration #

    To know the operation that triggered Change event & call iteration # to the same event My basic requirement is that I want to know 2 things when inside a “Worksheet_Change” event : #1 – What operation has caused this event to be triggered #2 – Whether this is the first call or second call to...

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