ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Expand the Height of a form if "Not Managed" selected (https://www.excelbanter.com/excel-programming/342082-expand-height-form-if-not-managed-selected.html)

Mark Cover

Expand the Height of a form if "Not Managed" selected
 
i need some ideas on expanding the height of a form when a comboBox item is
selected. I have the code to display the Items but cannot get the Height to
increase.
Here is what i have. Thanks
-mark
Private Sub cboSvctxt_Change()
If cboSvctxt.Value = "Not Managed" Then
Label12.Visible = True
Label13.Visible = True
txtHost.Visible = True
txtIP.Visible = True
ExpandForm 289
Else
End If
End Sub

Mark Cover

Expand the Height of a form if "Not Managed" selected
 
Ok Figured this one out. had to make a ExpandForm Sub function.
here is code if anyone cares...
rivate Sub ExpandForm(iTo As Integer)
Dim y As Long
If iTo Height Then
For x = Height To iTo
Height = x
GoSub ExpandFormLoop
Next
Else
For x = Height To iTo Step -1
Height = x
GoSub ExpandFormLoop
Next
End If
Exit Sub
ExpandFormLoop:
y = 0
Do
y = y + 1
Loop Until y = 2
Return
End Sub

"Mark Cover" wrote:

i need some ideas on expanding the height of a form when a comboBox item is
selected. I have the code to display the Items but cannot get the Height to
increase.
Here is what i have. Thanks
-mark
Private Sub cboSvctxt_Change()
If cboSvctxt.Value = "Not Managed" Then
Label12.Visible = True
Label13.Visible = True
txtHost.Visible = True
txtIP.Visible = True
ExpandForm 289
Else
End If
End Sub



All times are GMT +1. The time now is 12:16 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com