the refedit is a very problematic control.

there's hardly any documentation.
it will not work in modeless forms

it will present problems with focus (and out of sequence event
triggering) if contained in anything but the userform itself.

If possible: use a dialog. application.inputbox(type:=8)
If not: put it directly on the form, not inside a container
(frame/multipage etc)
Debugging:

Trace the refedit's exit event.
It MUST occur before you hide or close your userform.



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


T.c.Goosen1977 wrote in
<news:<T.c.Goosen1977.2aew7b_1152001202.5035@excel forum-nospam.com


Im struggling with the following:

Userform1 in sheet1 loads userform2 in sheet2...userform2 contains
scroll, zoom & RefEdit options on it..._terminating() userform2 loads
userform1 in sheet1 again..."cycle thing"...the cycle works perfectly
every time when i use both the scroll and zoom options on userform2
but when i use the RefEdit option on userform2 and when i then
terminating userform2 it loads again userform1 and goes into a
stalling / hanging mode....??

I would like to link in a later stage the RefEdit information to a
printing option...

I would appreciate some advice...thanks

Thanks
Theuns