Cell Value Change triggering UserForm

Hi Everybody !

Is there a way to have a user form triggered by an indirect cell change. For instance in my project, cell B1 is the sum of A1:A300. I know I can trigger a user form by entering any number in cell B1 if B1 is the target cell that triggers the user form. However, in my project, I am not selecting nor pressing enter in cell B1. Instead I enter the value in any of the A1:A300 cell which changes the value in cell B1 but unfortunately isn't triggering the user form. Anyone can help ?

Thanks in advance !!

Dany,

Code tags are required when you post VBA code, per forum rules (you did read them, right?).

Please edit your post to add the code tags, then someone will help.

Use code tags like this:

[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

Here's all I needed:

Please Login or Register  to view this content.

Thanks anyways for your help folks !!

Please add the code tags!