Navigating while userform is displayed

[scottscott]

Is it possible to allow the user to navigate through worksheets while a userform is displayed? I need to allow the user to look through the worksheets in order to select the proper data on the userform.

 

[SkipVought]

Hi,

You need to set the userform shomodal property to modeless

Skip,
[sup]Don't let the Diatribe...
talk you to death![/sup][sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[PHV]

Have a look at the Application.InputBox method (Type:=8)
You may also consider to make your UserForm non modal.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886