Hello All,
I am using a worksheet change event to run a macro when a specific range of cells change in the sheet. All is well when one makes the change while the worksheet is in focus ... i.e., the user is making changes directly on the sheet. The change event updates the y-axis of three charts setting all three with the same minimum and maximum values.
But, I also have a user form with text boxes. The user can enter a value in the text box, which then updates the worksheet. However, using this method to update the sheet does not trigger the change event on the sheet ... unless one were to select a cell on the worksheet and then the act of selecting the cell triggers the change event.
My question, is there a way for a change event to function when the worksheet does not have focus? If not, what do you think is the best way to accomplish this? Perhaps put a change event in the user form to run the macro that would update the worksheet in question? But that would take some time putting the change on multiple text boxes.
Any thoughts?
Thanks,
Steve
I am using a worksheet change event to run a macro when a specific range of cells change in the sheet. All is well when one makes the change while the worksheet is in focus ... i.e., the user is making changes directly on the sheet. The change event updates the y-axis of three charts setting all three with the same minimum and maximum values.
But, I also have a user form with text boxes. The user can enter a value in the text box, which then updates the worksheet. However, using this method to update the sheet does not trigger the change event on the sheet ... unless one were to select a cell on the worksheet and then the act of selecting the cell triggers the change event.
My question, is there a way for a change event to function when the worksheet does not have focus? If not, what do you think is the best way to accomplish this? Perhaps put a change event in the user form to run the macro that would update the worksheet in question? But that would take some time putting the change on multiple text boxes.
Any thoughts?
Thanks,
Steve