Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
any formula to convert numbers in word form, e.g. "2" as "Two"? | Excel Worksheet Functions | |||
function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
Questionnaire sheet: Select "yes" or "no," and only one can be selected | Excel Worksheet Functions | |||
if "a" selected from dropdown menu then show "K" in other cell | Excel Worksheet Functions |