Can RefEdit Contrl be Used on a Modeless Userform?
 

I always lost focus to any form: no Excel neither the Userform is
responsible after I use RefEdit on a modeless userform to select an range. I
had to use Ctrl+Alt+Del to kill Excel.

Is there anybody know the reason?

Thanks

Jerry

Can RefEdit Contrl be Used on a Modeless Userform?
 

The symptoms you describe are common. RefEdit is unsupported on a modeless
userform - you can't use it.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Jerry Louis" wrote in message
...
I always lost focus to any form: no Excel neither the Userform is
responsible after I use RefEdit on a modeless userform to select an range.
I
had to use Ctrl+Alt+Del to kill Excel.

Is there anybody know the reason?

Thanks

Jerry

Can RefEdit Contrl be Used on a Modeless Userform?
 

Thanks Rob.

I also found it from MSDN.

You cannot use a RefEdit control on a modeless user form. You can use the
ShowModal property to set a user form to modal.

"Rob van Gelder" wrote in message
...
The symptoms you describe are common. RefEdit is unsupported on a modeless
userform - you can't use it.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Jerry Louis" wrote in message
...
I always lost focus to any form: no Excel neither the Userform is
responsible after I use RefEdit on a modeless userform to select an
range.
I
had to use Ctrl+Alt+Del to kill Excel.

Is there anybody know the reason?

Thanks

Jerry

Can RefEdit Contrl be Used on a Modeless Userform?
 

It is also in the help for refedit. At least in xl2000

--
Regards,
Tom Ogilvy

"Jerry Louis" wrote in message
...
Thanks Rob.

I also found it from MSDN.

You cannot use a RefEdit control on a modeless user form. You can use the
ShowModal property to set a user form to modal.

"Rob van Gelder" wrote in message
...
The symptoms you describe are common. RefEdit is unsupported on a
modeless
userform - you can't use it.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Jerry Louis" wrote in message
...
I always lost focus to any form: no Excel neither the Userform is
responsible after I use RefEdit on a modeless userform to select an
range.
I
had to use Ctrl+Alt+Del to kill Excel.

Is there anybody know the reason?

Thanks

Jerry