Allow spreadsheet scrolling behind userform

's Computer Specifications

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?

's Computer Specifications

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

NickHK

"Frank Marousek" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó·s»D:%(E-Mail Removed)...
> 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?
>
>

's Computer Specifications

> Use vbModeless as the argument to Userform.Show

Works great... thank you.

Awesome help on this NG!

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Spreadsheet scrolling	=?Utf-8?B?amVybWluc2tpNzM=?=	Microsoft Excel Worksheet Functions	1	7th Nov 2007 02:00 PM
Userform: Display Scrolling View of Columns A:C	Corey	Microsoft Excel Programming	1	29th Jan 2007 06:37 PM
Excel Spreadsheet 10.0 - Scrolling Down - HELP	=?Utf-8?B?S25pY2hvbHM=?=	Microsoft Excel Programming	0	5th Jan 2006 04:04 PM
In Excel, my spreadsheet keeps on scrolling down a row or two.	=?Utf-8?B?SUROVFM=?=	Microsoft Excel Misc	1	27th Sep 2004 04:30 PM
Userform Reset After Scrolling	JoJo	Microsoft Excel Programming	0	2nd Jul 2004 05:26 AM