Allow application scrolling behind userform

[jkugizak]

Hello,

I would like to scroll and navigate around an excel worksheet while I have a userform open. I do not need to edit the worksheet. Any ideas?

If you need an example of what I am trying to do, open an excel worksheet and press Ctrl+F. Notice how the Find form is in front of the worksheet, but you can navigate around the worksheet while the Find form is open.

This is what I would like to do.

Not sure if this is important, but the sheet I need to navigate around has a command button embedded that shows the userform in question when clicked using this code:

Private Sub cmdDealEntry_Click()
    frmDealEntry.Show
End Sub

Thanks in advance.

 

[sous2817]

Try setting the Userform propery "ShowModal" to false. That will allow you to interact with the sheet while keeping the userform visable.

 

[jkugizak]

I knew it was something simple - thanks for your help