I'm using 3 refedit controls in a form and for some reason I can't figure out how to get it to trigger an event when the value of the control is changed. What I'd like to do is make it trigger an event so that when someone clicks onto the worksheet to change the range, it would cause the focus to the next refedit control so that they didn't have to go back and forth between the form and worksheet to select the 3 cells.
Does anyone have any idea on how to do this?
Does anyone have any idea on how to do this?
