View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris A[_3_] Chris A[_3_] is offline
external usenet poster
 
Posts: 11
Default Scaling controls

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