Hello:
I have a form with four buttons. The procudure under all of the buttons
shows a number of rows. When one of the buttons is pushed, it produces a
large number of rows, but really not that many, HOWEVER, I am then not able
to scroll vertically to see all of the records. THe form is set to modal =
false, and scrolling is enabled on the sheet. What's up? Is there something I
can add to the code to enable scrolling?

thanks, Germaine

userform1.show false

"Bettergains" wrote:

Hello:
I have a form with four buttons. The procudure under all of the buttons
shows a number of rows. When one of the buttons is pushed, it produces a
large number of rows, but really not that many, HOWEVER, I am then not able
to scroll vertically to see all of the records. THe form is set to modal =
false, and scrolling is enabled on the sheet. What's up? Is there something I
can add to the code to enable scrolling?

thanks, Germaine

Okay. Your answer is a bit cryptic however. I have tried putting this code
(myform.show false) into the code that launches the form (doesn't work
there), and into the bottom of the code that runs the particular button click
event in question. Neither is working. In any case, I am able to scroll
horizontally, but not vertically. This is the crux of the problem. When the
number of rows extend beyond the page view, I am unable to scroll vertically
to see any rows out of view. What am I missing?

This particular form has 4 buttons. When any are pushed, all the filters are
cleared and then columns are hidden and rows displayed per the value
selected.

This is one of two forms. The scrolling doesn't work even when the other
form has not been used or has been closed. (Using the default "x" in upper
right corner.)

Thanks, Germaine.

"JNW" wrote:

userform1.show false

"Bettergains" wrote:

Hello:
I have a form with four buttons. The procudure under all of the buttons
shows a number of rows. When one of the buttons is pushed, it produces a
large number of rows, but really not that many, HOWEVER, I am then not able
to scroll vertically to see all of the records. THe form is set to modal =
false, and scrolling is enabled on the sheet. What's up? Is there something I
can add to the code to enable scrolling?

thanks, Germaine

Alright, my user error. The window was split. The forms were not modal, so no
additional code was needed; simply turned off the split/freeze (can't
remember exactly which.)

"Bettergains" wrote:

Hello:
I have a form with four buttons. The procudure under all of the buttons
shows a number of rows. When one of the buttons is pushed, it produces a
large number of rows, but really not that many, HOWEVER, I am then not able
to scroll vertically to see all of the records. THe form is set to modal =
false, and scrolling is enabled on the sheet. What's up? Is there something I
can add to the code to enable scrolling?

thanks, Germaine