I've heard many tales of how 'buggy' the RefEdit control is. I use it in a
couple of userforms without any problem, but in those instances I don't
cycle between forms like you want to. I'm sure someone will come along with
the right answer soon, but if not it could just be down to the control's
behaviour being a bit erratic.

Regards,
Tim

"T.c.Goosen1977"
<T.c.Goosen1977.2adj4n_1151937603.1189@excelforu m-nospam.com wrote in
message news:T.c.Goosen1977.2adj4n_1151937603.1189@excelfo rum-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...terminating userform2 loads
then 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...can i send the small file.xls for some advice on
what's happening when the userform stalls on the RefEdit selection but
all the other Scroll and zoom options on the userform works perfectly

I would appreciate some advice...thanks

Thanks
Theuns


--
T.c.Goosen1977
------------------------------------------------------------------------
T.c.Goosen1977's Profile:
http://www.excelforum.com/member.php...o&userid=35895
View this thread: http://www.excelforum.com/showthread...hreadid=557851