View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ed Davis[_2_] Ed Davis[_2_] is offline
external usenet poster
 
Posts: 67
Default MsgBox from another sheet

I have three sheets with numbers in column H these numbers are generated
from other sheets with a link.
I am looking to have a popup msgbox whenever the last number in the column
range Row 4 through 34 falls below a given number. And display a warning the
number is at this level. It would need to popup on the active sheet when the
user is inputting data.
If the number keeps going below this number each time the user goes to the
next sheet it should popup again or Every time the number changes and is
below the given number.
I am sure there must be a way but after a day of searching the Internet I
had to come here.


--
Thank You in Advance
Ed Davis