I can have the girl at the office cut and paste it if need be. All it is is
just a list of offices in each state.

The coulmns go across on my worksheet. The example on that web page went
down the page. Do you know how big that worksheet would be to have 400
offices in 9 different states done that way.

What is going to be difficult is when the last choice "CLLI" is choose, I am
going to try and get it to auto fill the rest of the Info into the userform.
That should be fun.

"OssieMac" wrote:

Hi again Brian,

Userform.
There is no need for each user to run the code to find their own setting.
That code was for you to run on the computer on which you developed the
Userform. Just need a base for the code to start with. When you know what the
parameters are, just edit the code using the returned width and height and
the proportional calculation should adjust the size for the other users.
Unfortunately it is not foolproof coding and you still might find it
unsatisfactory depending on the resolutions being used.

I cant download the workbook from the page you gave me so really not much
chop. Says the page is unavailable.

Anyway I have come up with a solution to cascading ComboBoxes. (Pity it is
not Access because cascading ComboBoxes are basically built in; just need to
know how to manipulate them.)

However, you have now said that you dont want to re-type your raw data so
can you post a sample of your raw data for the combo boxes. Just a few lines
will do. Dont post customer names; just replace them with a bunch of As,
Bs and Cs etc. I want to see if my code will work with your data layout.

--
Regards,

OssieMac