It didn't work. My workbook look like this, sheet 2 is populated with formulas with Sheet1 cells as reference. If I change the cell value in Sheet1, Sheet2 cell value also changes. I wanted the excel to prompt a message when the cell value in sheet2 changes while Im entering a cell value in sheet1 since sheet2 will also change if I change sheet1.
![[LIVE] : ONE ลุมพินี 85 | คู่เอก "ยอดเหล็กเพชร vs ผึ้งหลวง"](http://i.ytimg.com/vi/Qq_19bnnxEo/mqdefault.jpg)
I have been using your videos as my source for my VBA project at work! Tks a lot!!!
Great to hear. Glad they are helping
Hi, by chance do you know if this could work if the contents of the cell isn't changed but rather the highlight (colour) of the cell changes?
There is no event that would trigger code on an highlight change
Is there any event that would trigger if a certain date has passed?@@EverydayVBAExcelTraining
That's cool! I've been looking for this for a while. Thank you !
that's great, how would I do the same if I needed to trigger a box depending on the vale in a range of cells?
You would calculate. Which would work if the sheet was small. If it was large it could slow it down a bit
what if b4 cell is number that to with constant formula in that cell ," how u will show msg box of that cell..plz let me know
You code might look something like this
Msgbox "text " & range("B4")
How about if you want msg box to populate on a specified sheet within workbook?
You could do a button for a specific sheet or you could do an on change event on the sheet
It didn't work. My workbook look like this, sheet 2 is populated with formulas with Sheet1 cells as reference. If I change the cell value in Sheet1, Sheet2 cell value also changes. I wanted the excel to prompt a message when the cell value in sheet2 changes while Im entering a cell value in sheet1 since sheet2 will also change if I change sheet1.
Is sheet2 a formula? If sheet2 only has formulas the actual cell doesn't change so the trigger will not happen
Thank You!
Appreciate the comment. Happy vbaing
How to create msgbox multiple cell or range of cell?
Are you asking if a range changes or a cell changes? If that is the case you could specify the target.