I want a form to popup when a H13 cell valur reaches 1500

[Jenkins27]

any idea how to get a form to automatically popup when the h13 cell reaches 1500

[MarvinP]

Hi Jenkins,

Find the attached with some event code (behind the worksheet, not in a module) that does what I think you want.

[Jenkins27]

thanks but that did not work for me.. im not sure why...
the form is called "MSGform"

[MarvinP]

Change my code to the following.

Please Login or Register  to view this content.

Did you put the above code behind the sheet that has the H13 in it that changes?
Did you rename your userform from Userform1 to MSGForm ?

[Jenkins27]

that code worked thank you