View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default 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