Is your refedit directly on the form?
(or is it in a container like a multipage or frame)

I've recently had to make this work for a refedit
contained in a frame on a multipage...

i did following (and it's plenty of code, testing and debugging....)

on RefEdit ENTER

disable queryclose
disable all controls on the userform except activepage
disable all controls on the active page except the frame
disable all controls in the frame except the refedit
ENABLE ONE button in the frame.
(user MUST click on this button to get out of the refedit..
which triggers the EXIT event that reverses the above...


I had to do this, and it was no joke.

The RefEdit is a control I'd avoid like the plague.
(however sometimes you can't)


See the question at the top of this post.
IF it's directly on the userform then YES i will help you find out
where it goes wrong and probably what to do about it..
IF its' directly on the userform then mail me an example. My email is
in my signature just add the @ and . in the appropriate places.

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


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


Hi, keepITcool you are the 1st to respond in 2 days... i got no
response from the group regarding my problem...your 1st part is greek
to me but debugging makes sense in tracing the Refedit exit before
terminating the userform...but i still don't know how to do it
because the moment of stalling there is no debugging response?... is
it possible to send u a small .xls file regarding a RefEdit
problem...i would really appriciate some advice.

Thanks
Theuns