0

I want to prompt the message box after the changing value of specific cell value.

I am using sheet change event but i want to do it manually using macro or instead of sheet change event is there any event like cell change event only for specific rangename.

i am already using worksheet_change i need event for a specific cell or specific range name.

can anyone suggest me macro or event for cell change?

Thanks in advance

Improve this question
7
  • 1
    You can use the Worksheet_Change event and just display the message box if Target is the cell (or part of the range) that you are interested in. There are many, many, many examples available, both here on Stack Overflow and elsewhere, to show you how to do this. Commented Jan 10, 2018 at 6:18
  • Keep in mind, Worksheet_Change will only work if you physically change the contents of the target cell(s), otherwise if your cell's value changes based on a formula, you might need to look at the Worksheet_Calculate event. Commented Jan 10, 2018 at 7:02
  • 1
    @L42 - FWIW, that "duplicate" has a terrible accepted answer. I don't know whether things were different back in 2009 (I don't think it was), but everything stated in the answer is inaccurate now. Commented Jan 10, 2018 at 7:06
  • @L42 I have just VTCed with that new link - it looks much better (and much closer to this question) than the first link you had. Not sure what will happen when the question does get closed - maybe it will list both duplicates, or maybe it will list the old one (which is currently 2 votes, versus the single vote on the new one). Commented Jan 10, 2018 at 8:00
  • i am using worksheet_change but that is heavy function means it every times execute when i am changing any cell of specific sheet Commented Jan 10, 2018 at 9:05
Related questions
2191
How do I create an Excel (.XLS and .XLSX) file in C# without installing Microsoft Office?
651
How can I avoid using Select in Excel VBA?
766
How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
Load 6 more related questions Show fewer related questions

0

Reset to default

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.