refedit does not allow selection in another workbook!

T

Taodf

refedit control in my UserForm does not allow the user to make a selection on
any other workbooks once the UserForm object displayed ,why?
Is it possible to tweak my function some more to make this possible?

But the refedit in FunctionWizardDialog allows the user to make a selection
on other workbooks. why?

Should I create a new thread to show my UserForm? How to create a new thread
in VBA?
Thanks!
 
Top