RefEdit irregular behavior - corrective measures wanted

[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

 

[Jon Peltier]

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