Allow Spreadsheet to be scrolled?
Hi,
Whenever I have a userForm popup on a spreadsheet, I can not scroll the spreadsheet while the userForm is displayed. Is there a way around this so that when a userform is displayed, I can also scroll throught the spread sheet?
What I want to do is to allow the user plot certian rows in a graph. So while the userform popups up asking the user to enter the rows, he/she can view the spread sheet at the same time.
Thanks!
Re: Allow Spreadsheet to be scrolled?
Instead of showing your userform Modally show it Modeless. ;)
VB Code:
UserForm1.Show vbModeless