scrolling in large form

auroastra · Apr 24th, 2002, 11:36 AM

Hello,
I have made a rather large (long) VB form for an excel sheet (1850 length) with 20 items but when I 'show' the form I cannot use the scroll bar in it....the whole form is displayed and I can only see 8 items and can only print 8 items on it (1/3 of the form). I can't find where to adjust this?
Halp,
chris

Jack in the UK · Apr 24th, 2002, 11:40 AM

check the scroll area setting, could be limited, to smaler selection

auroastra · Apr 24th, 2002, 12:13 PM

Hey,
Thanks, by reading this I see to start to fool around with the "Height" and "scroll" height settings for the form and it's working.

THANKS!!!!!!!!!~
Chris

Quote:

On 2002-04-24 10:40, Jack in the UK wrote:
check the scroll area setting, could be limited, to smaler selection

Jack in the UK · Apr 24th, 2002, 12:14 PM

well done!

Apr 24th, 2002, 11:40 AM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	check the scroll area setting, could be limited, to smaler selection __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Apr 24th, 2002, 12:14 PM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	well done! __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 24th, 2002, 11:36 AM	#1
auroastra New Member Join Date: Apr 2002 Posts: 17	Hello, I have made a rather large (long) VB form for an excel sheet (1850 length) with 20 items but when I 'show' the form I cannot use the scroll bar in it....the whole form is displayed and I can only see 8 items and can only print 8 items on it (1/3 of the form). I can't find where to adjust this? Halp, chris