Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
axis scaling | Charts and Charting in Excel | |||
Pie Charts - Scaling | Charts and Charting in Excel | |||
ActiveX Controls vs Form Controls | Excel Discussion (Misc queries) | |||
Dynamic Scaling | Charts and Charting in Excel | |||
Chart Scaling | Excel Programming |