ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Allow spreadsheet scrolling behind userform (https://www.excelbanter.com/excel-programming/375512-allow-spreadsheet-scrolling-behind-userform.html)

Frank Marousek

Allow spreadsheet scrolling behind userform
 
After I display a userform, is it possible to allow the user to scroll the
spreadsheet (behind the form) while keeping the form displayed on top?



NickHK[_3_]

Allow spreadsheet scrolling behind userform
 
Frank,
Use vbModeless as the argument to Userform.Show
- XL2000 (or 97?) and higher.

NickHK

"Frank Marousek" .gbl...
After I display a userform, is it possible to allow the user to scroll the
spreadsheet (behind the form) while keeping the form displayed on top?





Frank Marousek

Allow spreadsheet scrolling behind userform
 
Use vbModeless as the argument to Userform.Show

Works great... thank you.

Awesome help on this NG!




All times are GMT +1. The time now is 06:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com