Hello,
i am trying to create a automatic popup alert window. the window pops up after a certain criteria is reached. for instance, a stock price change not more than x% the alert window pops up.
the problem is that if i use the worksheet_change, or other events because the price change value is calculated by a excel formula, the value change couldn't trigger the event.
any thoughts?
thanks!
i am trying to create a automatic popup alert window. the window pops up after a certain criteria is reached. for instance, a stock price change not more than x% the alert window pops up.
the problem is that if i use the worksheet_change, or other events because the price change value is calculated by a excel formula, the value change couldn't trigger the event.
any thoughts?
thanks!