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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Oliver Kharraz wrote:

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