AW: Formel einfügen zu langsam
08.07.2006 10:07:17
Giuseppe
Hallo Gerd,
ich wollte so machen, aber kriege nicht hin.
Die Daten werden so übertragen:
Private Sub NEU_einfügen_Click()
NEU_eintragen.Enabled = True
Dateischutz_auf
If TextBox2 = "" Then
MsgBox "Inserire almeno un Nome nel campo 'Cliente'....."
TextBox2.SetFocus
Exit Sub
End If
Dim irisposta As Integer
irisposta = MsgBox("Inserire il nuovo Record con i dati di " & TextBox2.Value & " ?", vbYesNo)
If irisposta = vbYes Then
nuovocodice
Range("B2").Value = Worksheets("NominaCampi").Range("C5")
Range("B2").End(xlDown).Offset(1, 0).Select
ActiveCell.Value = TextBox2
'ActiveCell.Offset(0, -1).Value = iRow - 2
ActiveCell.Offset(0, 1).Value = TextBox3
ActiveCell.Offset(0, 2).Value = TextBox4
ActiveCell.Offset(0, 3).Value = TextBox5
ActiveCell.Offset(0, 4).Value = TextBox6
ActiveCell.Offset(0, 5).Value = TextBox7
ActiveCell.Offset(0, 6).Value = TextBox8
ActiveCell.Offset(0, 7).Value = TextBox9
ActiveCell.Offset(0, 8).Value = TextBox10
ActiveCell.Offset(0, 9).Value = TextBox11
ActiveCell.Offset(0, 10).Value = TextBox12
ActiveCell.Offset(0, 11).Value = TextBox13
ActiveCell.Offset(0, 12).Value = TextBox14
ActiveCell.Offset(0, 13).Value = TextBox15
ActiveCell.Offset(0, 14).Value = TextBox16
ActiveCell.Offset(0, 15).Value = TextBox17
ActiveCell.Offset(0, 16).Value = TextBox18
ActiveCell.Offset(0, 17).Value = TextBox19
ActiveCell.Offset(0, 18).Value = TextBox20
ActiveCell.Offset(0, 19).Value = TextBox21
ActiveCell.Offset(0, 20).Value = TextBox22
ActiveCell.Offset(0, 21).Value = TextBox23
ActiveCell.Offset(0, 22).Value = TextBox24
If TextBox24.Value <> "" Then ActiveCell.Offset(0, 22).Value = ""
ActiveCell.Offset(0, 23).Value = TextBox25
If TextBox25.Value <> "" Then ActiveCell.Offset(0, 23).Value = ""
ActiveCell.Offset(0, 24).Value = TextBox26
If TextBox26.Value <> "" Then ActiveCell.Offset(0, 24).Value = ""
ActiveCell.Offset(0, 25).Value = TextBox27
ActiveCell.Offset(0, 26).Value = TextBox28
ActiveCell.Offset(0, 27).Value = TextBox29
ActiveCell.Offset(0, 28).Value = TextBox30
ActiveCell.Offset(0, 29).Value = TextBox31
ActiveCell.Offset(0, 30).Value = TextBox32
ActiveCell.Offset(0, 31).Value = TextBox33
ActiveCell.Offset(0, 32).Value = TextBox34
ActiveCell.Offset(0, 33).Value = TextBox35
ActiveCell.Offset(0, 34).Value = TextBox36
ActiveCell.Offset(0, 35).Value = TextBox37
ActiveCell.Offset(0, 36).Value = TextBox38
ActiveCell.Offset(0, 37).Value = TextBox39
ActiveCell.Offset(0, 38).Value = TextBox40
ActiveCell.Offset(0, 39).Value = TextBox41
ActiveCell.Offset(0, 40).Value = TextBox3.Value & " " & TextBox41.Value
ActiveCell.Offset(0, 41).Value = TextBox43
'MEIN VERSUCH DIE FORMEL EINZUFÜGEN!!!!!
'ActiveCell.Offset(0, 42).Value = ActiveCell.FormulaR1C1 = _
"=IF(RC[-42]=""."",TEXT(RC[-1],) &"" ""&TEXT(RC[-23],),TEXT(RC[-1],) &"" ""&TEXT(RC[-42],)&"" ""&TEXT(RC[-23],))"
'Selection.AutoFill Destination:=Range(Cells(loLetzte, 42), Cells(loLetzte + 1, 42)), Type:=xlFillDefault
'ActiveCell.Offset(0, 43).Value = TextBox45
Y = [a3].End(xlDown).Row
Label101.Caption = Y - 2 & " Record presenti"
' HIER ist noch code
Dim f As Integer
For f = 1 To 45
Controls("TextBox" & f) = ""
Next
Y = [a3].End(xlDown).Row
Label101.Caption = Y - 2 & " Record presenti"
Aggiornamento_CodCat
'Attualizza_AAA
End If
End If
'Aggiungi_formula
End Sub
statt die Formel die Zelle füllt sich mi FALSCH
Ciao
Giuseppe