View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default Having trouble with combo boxes.

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