nightjar
07-16-2010, 02:17 AM
Hi,
I'm capturing user input with a userform displayed in a loop, using the Userform_Activate event to clear the form before redisplaying ready for new input. This is working perfectly in Excel 2003, but on testing in Excel 97 it seems the activate event is not being triggered (and the data in the form isn't cleared). As I understand it on executing Hide, the userform should lose focus, but this isn't happening in 97 (the Deactivate event doesn't fire either). I've tried explicitly activating a worksheet immediately prior to the Show command with no effect - any other suggestions gratefully received - unfortunately I do need this to work in Excel 97! Many thanks.
I'm capturing user input with a userform displayed in a loop, using the Userform_Activate event to clear the form before redisplaying ready for new input. This is working perfectly in Excel 2003, but on testing in Excel 97 it seems the activate event is not being triggered (and the data in the form isn't cleared). As I understand it on executing Hide, the userform should lose focus, but this isn't happening in 97 (the Deactivate event doesn't fire either). I've tried explicitly activating a worksheet immediately prior to the Show command with no effect - any other suggestions gratefully received - unfortunately I do need this to work in Excel 97! Many thanks.