Scaling controls

C

Chris A

More problems.
How can i resize all the controls on a userform to accomodate 3 different
screen resolutions. I have tried cycling through controls and scaling like
so:

For i = 1 To 5
Controls("combobox" & i).Height = Controls("combobox" & i).Height * 0.78125
Controls("combobox" & i).Width = Controls("combobox" & i).Width * 0.78125
Controls("combobox" & i).Left = Controls("combobox" & i).Left * 0.78125
Controls("combobox" & i).Top = Controls("combobox" & i).Top * 0.78125
Controls("combobox" & i).Font.Size = 9
Next i

But it's not exactly precise, things go to pot. is there something i can do
to get better scaling, I have tried something years back in VB4 using twips,
a brief encounter, can i make VBA use twips?

Any help would be apprecaited, Thanks

Chris A
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ComboBox Dropdown not under control 1
Run time error adding controls to form programatically 0
Table Preferred width is changed when pasting 1
VBE tricky question 2
width of combo box control on toolbar 1
Listboxes Without User Form 6
Position Userform In Cells Portion of Excel Only 1
How to keep comboboxes stationary 0

Top