RefEdit problems

[T.c.Goosen1977]

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

 

[Tim Marsh]

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"

 

[Jim Cone]

Buggy is an understatement.

Why don't you see if you can figure out what this MS article means...
http://support.microsoft.com/?kbid=177632
"Xl97: Refedit Control Still Appears After You Close Userform"

And just think, you paid for the above help.
The best advice I can give on using the RefEdit control is to "never" set
the focus to the control.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"T.c.Goosen1977"
wrote in message
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