Can RefEdit Contrl be Used on a Modeless Userform?

J

Jerry Louis

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
 
R

Rob van Gelder

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

Jerry Louis

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.
 
Top