Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Modeless userform | New Users to Excel | |||
Modeless userform | Excel Programming | |||
Disable close button of Modeless Userform | Excel Programming | |||
Focus back from modeless userform to sheet | Excel Programming | |||
UserForm with RefEdit Modality Issue | Excel Programming |