Allowing scroll bar

[knightengale]

Question. I am creating an excel form that allows the preview of the information on an excel sheet.

Once this information is displayed I have a Msgbox displayed to allow the return to the Form.

Now my concern is that i need to be able to enable to scroll bars on the sheet without unloading the form.

Any why of doing this?

Thanks for the help

 

[DominicB]

Good morning knightengale

Assuming that you're using UserForms as the basis for your form, then use something like this to call your userform :

Sub test()
UserForm1.Show vbModeless
End Sub

This will allow you to scroll around your workbook while the form is on screen.

HTH

DominicB