sb fredster
New Member
- Joined
- Mar 10, 2002
- Messages
- 3
I am trying to use the worksheet_change event to trigger some VBA in a worksheet. I want to have the code execute when values in column B change. Column B is currently a lookup formula that gets values from a table. What I want to occur is the following: Table values are updated, then column B recalculates picking up the new values, as each cell in column B gets its new lookup value, an event is triggered and the cell reference is returned. I can then evaluate the returned value in my VBA code, evaluate the change, and then go on to the next value that changed in column B.
By application relates to stock prices and monitors when certain floor or ceiling prices are hit for different stock holdings. The lookup table is used as an efficient way of getting stock prices where many positions exist for each price.
THANKS in advance for any input from the gurus (you know who you are!)
By application relates to stock prices and monitors when certain floor or ceiling prices are hit for different stock holdings. The lookup table is used as an efficient way of getting stock prices where many positions exist for each price.
THANKS in advance for any input from the gurus (you know who you are!)