Detecting changes

M

Mileshigh

Board Regular
Joined
Oct 1, 2008
Messages
54
Is there a way to have vba detect if changes have been made so that a msgbox can prompt the user to accept or decline changes made?
 

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
Sort by date Sort by votes
Yep, just use the following to add your code for what changes to watch for and what to do when they happen.

Code: 
Private Sub Worksheet_Change(ByVal Target As Range)
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

C
  • Solved
"Either or" condition in SUMPRODUCT
Replies
2
Views
184
cichli_04
C
R
  • Question Question
I need to return a lookup on a table once a slicer has been selected.
Replies
3
Views
518
JamesCanale
JamesCanale
M
  • Question Question
Prevent worksheet change from triggering when similar macro is executed?
Replies
1
Views
142
AlphaFrog
AlphaFrog
R
  • Question Question
Time sheet formulas
Replies
2
Views
363
rodnaaaaay
R
B
  • Question Question
Fix AutoFit Row Height gap with vba
Replies
9
Views
227
Bond00
B

Forum statistics

Threads
1,224,609
Messages
6,179,881
Members
452,948
Latest member
Dupuhini

Share this page

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