View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default scrollbar on userform

There are properties for the UserForm.

Try playing with
ScrollBars = fmScrollBarsBoth
ScrollHeight = 5000
ScrollWidth = 5000

Then at design time, you can place controls outside of the visible area by
using the scrollbars.


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"S.Hoitinga" wrote in message
...
Hi,

I created a form with user instructions on how to work with

key-combinations
in excel and saved it as an xla.
The form pops up on key ctrl+shift+X.

The form covers more or less the complete monitor-window (especially on
monitors of 15" or less).
Now I would like to place a scroll-bar on the form, which would it

possible
to show only an small part of the form.
I placed a scroll-bar on the form, but I can't figure out what the code
should be to have the form scrolling in its window.

Does anyone have any suggestions?

Any help is greatly appreciated.

Sybolt