Refedit control modal issue

[gtmeloney]

I am using a refEdit control on a userform to get a range from the user (they use the refEdit control to click on the desired range). My problem is that the user typically has 3 or 4 different workbooks open and if one of them is maximized withing Excel, the user is unable to get to them to select the range (only the maximized workbook is displayed and usable). Is there a way around this?

[gtmeloney]

I think that my problem stems from the fact that the userform that my refEdit control lives on is modal, but it needs to be that way. Any ideas?

Note: If you setup an Advanced Filter in Excel there is a refEdit control that allows you to minimize and maximize workbooks while it is running. How do I get one of these?

[gtmeloney]

Any help on modality would be appreciated here. I'm pretty sure that my issue stems from the fact that my userForm is modal, but it has to be modal inorder to force the user to provide input to the form before continuing with code execution

[shg]

The RefEdit must be on a modal form to work at all. I don't know how AdvancedFilter does it, but you could add a button to the form that hides it (and caches the currently active sheet) to let the user selected the desired workbook, sheet, and range.

[gtmeloney]

The fix that I used was to create a button that when pushed displayed all of the active workbooks.

Please Login or Register  to view this content.

http://www.excelforum.com/excel-prog...nge-value.html

Thanks, shg