RefEdit irregular behavior - corrective measures wanted

  • Thread starter Thread starter Oliver Kharraz
  • Start date Start date
O

Oliver Kharraz

Hello,

I am using a refedit control in a modal user form, and am trying to copy its
contents upon exit, using the exit function. This causes Excel to crash. I
played around with the code and learned that the procedure gets called and
executed, but crashes afterwards. Any idea/experience?

Thanks so much,

Oliver
 
Oliver -

Some of the RefEdit events are unpredictable (or as you've discovered,
predictable in a bad way). To get the contents of the RefEdit, or to
validate the range, you should rely on another event, perhaps on the
user clicking the OK button, or something similar.

- Jon
 
Back
Top