RefEdit irregular behavior - corrective measures wanted
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 |
RefEdit irregular behavior - corrective measures wanted
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 |
All times are GMT +1. The time now is 07:29 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com