Insert a new form, put some controls on it.
In the Properties window in the VBE...
Set ScrollBars to "3 - fmScrollBarsBoth"
Set ScrollHeight to approximately twice the form height.
Set ScrollWidth to approximately twice the form width.
Show the form and try it.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




"Pam"
wrote in message
I have tried everything to get my scroll bars to work in my form. Even to the
point of trying to shrink my information down in my form so I wouldn't have
to use them.
I am new to VB, but I have done some programing, just not an extensive form.
I have a form that started out in VB for applications, so that it could dump
into an excel worksheet when it was filled out.
I have tried the instructions at
http://articles.techrepublic.com.com...1-5355438.html in the VB for
Apps as well as in VB 2008 Express that I downloaded. I get the form, the
code will not work, I don't know if I have to declare something, or even how
to declare something.
I have also tried putting the form with a picture box and putting the scroll
on the picture box. The scroll bar moves, but the picture box does not.
I have worked on this for 12 hours, and I know it has to be something really
simple, but it's killing me.
I'm also not sure if this is the right place to post this, but was told in a
developer forum that this forum might be able to help me with the vba, but
maybe not the 2008 Express.
Any help would be appreciated.
Thank you.