alifatehi
جمعه 07 تیر 1387, 14:20 عصر
لطف کنید بیندید اشتباه من در این کد چیست؟
هدف این کد این است که 10 مقدار در ون لیست یک کمبو باکس است . که می خواهم با انتخاب هر عدد به همان مقدار frame نمایش بده
سوال دوم این است که می توان طوری طراحی کرد که زمانی که آخرین عدد که عدد 10 است انتخاب شود و فرم به دلیل کمبود جا از Scrollbar استفاده کند ( از هر کس می پرسم کسی بلد نیست)
این کد است
خطا اینجاست Private Sub cboNuChek_Click()
' hide and show farm
If cboNuChek.List(cboNuChek.ListIndex) = 1 Then
FraCkek1.Visible = True
FraCkek2.Visible = False
FraCkek3.Visible = False
' FraCkek4.Visible = False
' FraCkek5.Visible = False
' FraCkek6.Visible = False
' FraCkek7.Visible = False
'FraCkek8.Visible = False
' FraCkek9.Visible = False
' FraCkek10.Visible = False
End If
If cboNuChek.List(cboNuChek.ListIndex) = 2 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
' FraCkek3.Visible = False
' FraCkek4.Visible = False
' FraCkek5.Visible = False
' FraCkek6.Visible = False
' FraCkek7.Visible = False
' FraCkek8.Visible = False
' FraCkek9.Visible = False
' FraCkek10.Visible = False
End If
If cboNuChek.List(cboNuChek.ListIndex) = 3 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = False
FraCkek5.Visible = False
FraCkek6.Visible = False
FraCkek7.Visible = False
FraCkek8.Visible = False
FraCkek9.Visible = False
FraCkek10.Visible = False
End If
If cboNuChek.List(cboNuChek.ListIndex) = 4 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
Line1.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 5 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
Line1.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 6 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
FraCkek6.Visible = True
Line1.Visible = True
Line2.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 7 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
FraCkek6.Visible = True
FraCkek7.Visible = True
Line1.Visible = True
Line2.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 8 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
FraCkek6.Visible = True
FraCkek7.Visible = True
FraCkek8.Visible = True
Line1.Visible = True
Line2.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 9 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
FraCkek6.Visible = True
FraCkek7.Visible = True
FraCkek8.Visible = True
FraCkek9.Visible = True
Line1.Visible = True
Line2.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 10 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
FraCkek6.Visible = True
FraCkek7.Visible = True
FraCkek8.Visible = True
FraCkek9.Visible = True
FraCkek10.Visible = True
Line1.Visible = True
Line2.Visible = True
End If
هدف این کد این است که 10 مقدار در ون لیست یک کمبو باکس است . که می خواهم با انتخاب هر عدد به همان مقدار frame نمایش بده
سوال دوم این است که می توان طوری طراحی کرد که زمانی که آخرین عدد که عدد 10 است انتخاب شود و فرم به دلیل کمبود جا از Scrollbar استفاده کند ( از هر کس می پرسم کسی بلد نیست)
این کد است
خطا اینجاست Private Sub cboNuChek_Click()
' hide and show farm
If cboNuChek.List(cboNuChek.ListIndex) = 1 Then
FraCkek1.Visible = True
FraCkek2.Visible = False
FraCkek3.Visible = False
' FraCkek4.Visible = False
' FraCkek5.Visible = False
' FraCkek6.Visible = False
' FraCkek7.Visible = False
'FraCkek8.Visible = False
' FraCkek9.Visible = False
' FraCkek10.Visible = False
End If
If cboNuChek.List(cboNuChek.ListIndex) = 2 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
' FraCkek3.Visible = False
' FraCkek4.Visible = False
' FraCkek5.Visible = False
' FraCkek6.Visible = False
' FraCkek7.Visible = False
' FraCkek8.Visible = False
' FraCkek9.Visible = False
' FraCkek10.Visible = False
End If
If cboNuChek.List(cboNuChek.ListIndex) = 3 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = False
FraCkek5.Visible = False
FraCkek6.Visible = False
FraCkek7.Visible = False
FraCkek8.Visible = False
FraCkek9.Visible = False
FraCkek10.Visible = False
End If
If cboNuChek.List(cboNuChek.ListIndex) = 4 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
Line1.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 5 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
Line1.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 6 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
FraCkek6.Visible = True
Line1.Visible = True
Line2.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 7 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
FraCkek6.Visible = True
FraCkek7.Visible = True
Line1.Visible = True
Line2.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 8 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
FraCkek6.Visible = True
FraCkek7.Visible = True
FraCkek8.Visible = True
Line1.Visible = True
Line2.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 9 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
FraCkek6.Visible = True
FraCkek7.Visible = True
FraCkek8.Visible = True
FraCkek9.Visible = True
Line1.Visible = True
Line2.Visible = True
End If
If cboNuChek.List(cboNuChek.ListIndex) = 10 Then
FraCkek1.Visible = True
FraCkek2.Visible = True
FraCkek3.Visible = True
FraCkek4.Visible = True
FraCkek5.Visible = True
FraCkek6.Visible = True
FraCkek7.Visible = True
FraCkek8.Visible = True
FraCkek9.Visible = True
FraCkek10.Visible = True
Line1.Visible = True
Line2.Visible = True
End If