Es werden eigentlich nur Labels ein- bzw. ausgeblendet. Schrittweise im Debugger klappt alles, wird das Formular jedoch normal ausgeführt und dann die ComboBox geändert, stürzt Excel ab...
ich bin echt mit meinem latein an ende...
Private Sub UserForm_Initialize()
Monate = Array("Januar", "Februar", "März", "April", "Mai", "Juni", _
"Juli", "August", "September", "Oktober", "November", "Dezember")
ComboBoxMonat.List = Monate
End Sub
Private Sub ComboBoxMonat_Change()
Dim Index2 as Integer
Index2 = ComboBoxMonat.ListIndex
''''' Tage Ein- bzw. ausblenden, je nach Tagen pro Monat'''''
Select Case Index2
Case 0
Monat = 1
Tagemax = 31
Label122.Visible = True: Label123.Visible = True: Label124.Visible = True
Label29.Visible = True: Label30.Visible = True: Label31.Visible = True
Label60.Visible = True: Label61.Visible = True: Label62.Visible = True
Label91.Visible = True: Label92.Visible = True: Label93.Visible = True
Label153.Visible = True: Label154.Visible = True: Label155.Visible = True
Label494.Visible = True: Label495.Visible = True: Label496.Visible = True
Label215.Visible = True: Label216.Visible = True: Label217.Visible = True
Label246.Visible = True: Label247.Visible = True: Label248.Visible = True
Label277.Visible = True: Label278.Visible = True: Label279.Visible = True
Label308.Visible = True: Label309.Visible = True: Label310.Visible = True
Label339.Visible = True: Label340.Visible = True: Label341.Visible = True
Label370.Visible = True: Label371.Visible = True: Label372.Visible = True
Label401.Visible = True: Label402.Visible = True: Label403.Visible = True
Label432.Visible = True: Label433.Visible = True: Label434.Visible = True
Label463.Visible = True: Label464.Visible = True: Label465.Visible = True
Case 1
Monat = 2
Tagemax = 28
Label122.Visible = False: Label123.Visible = False: Label124.Visible = False
Label29.Visible = False: Label30.Visible = False: Label31.Visible = False
Label60.Visible = False: Label61.Visible = False: Label62.Visible = False
Label91.Visible = False: Label92.Visible = False: Label93.Visible = False
Label153.Visible = False: Label154.Visible = False: Label155.Visible = False
Label494.Visible = False: Label495.Visible = False: Label496.Visible = False
Label215.Visible = False: Label216.Visible = False: Label217.Visible = False
Label246.Visible = False: Label247.Visible = False: Label248.Visible = False
Label277.Visible = False: Label278.Visible = False: Label279.Visible = False
Label308.Visible = False: Label309.Visible = False: Label310.Visible = False
Label339.Visible = False: Label340.Visible = False: Label341.Visible = False
Label370.Visible = False: Label371.Visible = False: Label372.Visible = False
Label401.Visible = False: Label402.Visible = False: Label403.Visible = False
Label432.Visible = False: Label433.Visible = False: Label434.Visible = False
Label463.Visible = False: Label464.Visible = False: Label465.Visible = False
' Case 2
' entsprechend den obigen Case-Anweisungen, für die Monate 2-11
End Select
End Sub