Re: Sheet berechnet Datum nicht
27.04.2003 17:10:39
MARCO HOFBAUER
Hallo Rainer Habe hier mein Cods mit Deiner Variante funzt bei mir nicht-.
Würdest Du diesen mal anschauen ??
Besten Dank Marco
Private Sub TB8_Exit(ByVal Cancel As MSForms.ReturnBoolean)
' eingabe Datum Erzwingen
Dim Eroeffnung As String
With TB8
If Not IsDate(.Text) Then
.Text = "Kein Datum!"
.SelStart = 0
.SelLength = .TextLength
.BackColor = &HC0FFFF
Cancel = True
Else
.BackColor = &HE0E0E0
Sheets("BF").Select
With ActiveSheet
.[Eroeffnung] = Format(DateValue(Me.TB8), "dd.mm.yyyy")
End With
End If
End With
End Sub
Sub BerechnenDatenblatt()
Sheets("BF").Select
SendKeys "{F9}"
ActiveSheet.Calculate
Sheets("Daten").Select
End Sub
''Daten mit der Wartefrist und den drei Varianten zurückschreiben
Private Sub TB9_Change()
BerechnenDatenblatt
If TB9.Value = "Rechnung" Then
With TB10
.BackColor = &HC0C000
.Locked = True
.SpecialEffect = fmSpecialEffectEtched
.Value = "."
.ForeColor = &HC0C000
End With
With TB11
.BackColor = &HC0C000
.Locked = True
.SpecialEffect = fmSpecialEffectEtched
.Value = ""
End With
TB12.Value = [u2_EV].Value
If [u2_EV].Value = Now Then
TB13.Text = "Ja"
Else
TB13.Text = "Nein"
End If
TB14.Value = [u2_pa].Value
TB15.Text = "Nein"
TB16.Value = [u2_rip].Value
TB17.Text = "Nein"
Else
With TB10
.BackColor = &HE0E0E0
.Locked = False
.SpecialEffect = fmSpecialEffectSunken
.Value = [u1_Ea].Value
.ForeColor = &H0&
End With
TB10.Text = [u1_Ea].Value
With TB11
.BackColor = &HE0E0E0
.Locked = False
.SpecialEffect = fmSpecialEffectSunken
End With
If [u1_Ea].Value = Now Then
TB11.Text = [u1_Ea].Value
Else
TB11.Text = "Nein"
End If
TB12.Value = [u1_Ea].Value
TB13.Text = "Nein"
TB14.Value = [u1_pa].Value
TB15.Text = "Nein"
TB16.Value = [u1_rip].Value
TB17.Text = "Nein"
End If
End Sub