Set Userform to Monitor Resolution

Is it reasonable, or possible, to try to set a userform to size it with a different screen resolution?

We have a few systems that are set to a screen resolution of 800 x 600 and I usualy try to set to that resolution for any userforms or setting individual sheet zoom resolution.

For individual sheet resolution I frequently use something like:

Please Login or Register  to view this content.

However, this does nothing for the userform. If a user opens the workbook with a screen resolution of 1024 x 768 or even greater the userform starts to look rather small.

Is there a way to detect what the screen resolution might be, set som constants accordingly and change the individual sheet zoom as well as the userform sizing?

If so, where can I find examples?

After I posed my question, I started thinking:
"If I can scale an individual sheet using the code I had in my earlier message, why bother with a UserForm at all?"

What I am now attempting to do is set up four individual worksheets that will resemble userforms. By that I mean I am applying a light gray background, using border shading to make things appear to be raised or sunken, right on the sheet, locking and unlocking certain cells, etc, the worksheet range becomes the equivalent of a Userform.

I am attaching *.jpg docs to show my Spreadsheet Userforms...

I don't know what terminology you use, but I just had one of those "Eureka" moments. Now I don't have to worry about any scaling except to make the worksheet range change the zoom once a session and my "Userform" now takes up the primary working space of the Excel Window.

I even think the coding to move data to the database portion will be more simple.

Simple is way better.