Custom Dialog Box Property 2

[clouddog9]

This may be a bizarre question and it may not even have an answer (aside from "NO"). Is there a user form property that will allow the user to scroll/select/edit a spreadsheet while the form is visible? I had in mind something similar to the way that the "Find" form works.

Don't ask for the code Skip

 

[SkipVought]

hi,

Check out the modal constants (vbModal & vbModeless) for the Show method

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[fumei]

With the userform,change the ShowModal property from True (the default) to False.

Now you have the userform visible, and assuming you have NOT made the application .Visible = False, you can click into the spradsheet and do whatever you want. To get focus back to the userform, click it.


unknown

 

[clouddog9]

You both rock. Stars for the both of you.