View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
 
Posts: 683
Default Having trouble with combo boxes.

I like the way the resize works that you posted.


I set it up the test program as a Macro seperate from the program. The user
can run that macro first to get there settings. Can we add a text box for the
user to adjust there settings without having to go into the code? Something
like?

A text box for dblMultWdth = vidWidth / 1446
A text box for dblMultHt = vidHeight / 816

A spin Button for .Zoom = 75 * dblZoom
A spin Button for .Top = 2
A spin Button for .Left = 35

THanks so much for your help on this, I was starting to worry about if it
could be done.

"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