Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating % of different measures taken | Excel Discussion (Misc queries) | |||
I need a Corrective Action Database template | Excel Discussion (Misc queries) | |||
desperate measures | Excel Worksheet Functions | |||
WANTED: Excel template for loan payment record with random/irregular payments | Excel Discussion (Misc queries) | |||
Take a look at this corrective patch which comes from the Microsoft Corp. | Excel Programming |