Can RefEdit Contrl be Used on a Modeless Userform?

  • Thread starter Thread starter Jerry Louis
  • Start date Start date
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
 
The symptoms you describe are common. RefEdit is unsupported on a modeless
userform - you can't use it.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RefEdit on Userform to pick up range in another workbook 1
Strange RefEdit Problem 12
Help needed with a RefEdit control 2
Refedit Retaining Focus 5
Refedit (can't get to work at all) 3
RefEdit 6
refedit won't work 8
refedits in a userform control class 10

Back
Top