View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul D.[_2_] Paul D.[_2_] is offline
external usenet poster
 
Posts: 18
Default userform_keypress event

I have 15 or so controls on a userform. I want to display a reminder message
to save changes if a change was made to any of the controls on the userform.
I was able to do this by placing a single boolean variable assignment in each
of 15 or so control_keypress events. I would like to get rid all the keypress
events and replace them with a single userform_keypress event. The variable
assignment in the userform_keypress event doesn't work. Any suggestions???
Excel 2002 w/ sp2
Thanks PD