After your last post I went on a "Where's Waldo' search for anything on
Cascading Combo Boxes. I found some code that looks like it would work,
except for the fact that i don't under stand it or how it works. Plus there
table is layed out odd. My Worksheet is just a standard table with names,
address, zip, etc... The problem is that if I have to retype them it's going
to take 2 months.

Whats so bad is I only have 2 major hurdles to over come to basically
complete this program.

1: User Form Resize
2: Cascading Combo Boxes

I didn't understand this code, but you probaly will look at it and
understand it. I know that you will have more of a clue than I will.

http://www.xldynamic.com/source/xld.Dropdowns.html

It might come down to paying someone to write the code for resizing the User
Form and thats Ok as long as it gets done. "SOON" LOL

Thanks for all your help


"OssieMac" wrote:

Don't worry about it Brian. I interpreted it as as simple frustration and I
fully understand that; I often get like it. Matter of fact I am approaching
it now because I am having trouble with the cascading combo boxes; nearly
there and can't get the last bit correct and not sure that I can.

Did you check out my latest option on your other thread for the userform size?

Unfortunately the userform thing is an inaccurate science because when you
adjust the screen resolution the height and width do not remain proportional.
You can adjust the form size quite well but you need to Zoom to adjust the
size of the controls in the form and the zoom affects both height and width
and if not proportional it does not work well.

It would be a lot of work but it should be possibe to identify the screen
resolution and then set the form size and then separately set the size and
position of all the controls in the form.

--
Regards,

OssieMac