Excel 2000 VBA form questions

[Doobage20]

I am making a form in Excel 2000 which when double clicking the file will
automatically come up. Because of the different size monitors/LCDs I have
run into a few questions.

1.) is there a way to automatically adjust the form to fit the screen; or
2.) how do you put the scrolls in so people with smaller monitors can use
the form.
3.) also, since the plain Excel workbook is not being used, is there a way
to minimize it when the form is brought up?

Doobage

 

[RyanH]

You can do a few things.

1.) You can adjust the Zoom Property of the Userform in the Properties
Window.

2.) You can set the Scroll Bars Property of the Userform in the Properties
Window equal to 3- fmScrollBarsBoth. This will give the users an ability to
scroll up & down and left & right.

3.) Assuming the Workbook you are talking about is the ActiveWindow you can
use this. This will minimize the ActiveWindow.

ActiveWindow.WindowState = xlMinimized

Hope this helps! If so, let me know and click "YES" below.

 

[Doobage20]

Open 1 will work but it will make the form window smaller for all users
instead of making the form smaller for users with monitors/LCD that are 14/15
inches. Would there be a command to auto adjust the form size?

On option 2 I had them set to 3- fmScrollBarsBoth on the ScrollBars and the
KeepScrollBarsVisible. But I do not get the 'slider' on smaller monitors. I
made the ScrollHeight = 100 and the ScrollWidth = 100 but could not change
the ScrollLeft and ScrollTop from 0.

On option 3 I was able to minimize all open books. Is there a was to
minimize all of Excel except the form? I don't think so but I thought I
would ask.

Doobage