VBA Popup besked
Hej jeg har lavet denne makro hvor der kommer en besked op hvor den spørg om man vil overføre noget data. Nu ønsker jeg så at når dataen er overført så skal der komme en ny popup hvor der står "Dataen er nu Overført" hvordan laver man den??Sub Overførdata_okrep()
'
' Overførdata_okrep Makro
'
'
Dim Answer As VbMsgBoxResult
Answer = MsgBox("Er du sikker på du vil overføre Data til OK Rep. listen?", vbYesNo, "Overfør Data")
If Answer = vbYes Then
Range("C2").Select
Selection.Copy
Sheets("OK Rep.").Select
Range("Tabel1[[#Headers],[Kunde]]").Select
Selection.End(xlDown).Select
ActiveCell.Offset(1, 0).Range("Tabel1[[#Headers],[ ]]").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("Tabel1[[#Headers],[ ]]").Select
Sheets("Opret OK rep.").Select
Range("C3").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("OK Rep.").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("Tabel1[[#Headers],[ ]]").Select
Sheets("Opret OK rep.").Select
Range("C4").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("OK Rep.").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("Tabel1[[#Headers],[ ]]").Select
Sheets("Opret OK rep.").Select
Range("C5").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("OK Rep.").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("Tabel1[[#Headers],[ ]]").Select
Sheets("Opret OK rep.").Select
Range("C6").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("OK Rep.").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("Tabel1[[#Headers],[ ]]").Select
Sheets("Opret OK rep.").Select
Range("C7").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("OK Rep.").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("Tabel1[[#Headers],[ ]]").Select
Sheets("Opret OK rep.").Select
Range("C8").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("OK Rep.").Select
Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
xlNone, SkipBlanks:=False, Transpose:=False
ActiveCell.Offset(0, 1).Range("Tabel1[[#Headers],[ ]]").Select
Sheets("Opret OK rep.").Select
Range("C9").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("OK Rep.").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
ActiveCell.Offset(-87, -8).Range("Tabel1[[#Headers],[ ]]").Select
Sheets("OK rep.").Select
Range("A1").Select
Sheets("Opret OK rep.").Select
Range("C2").Select
End If
End Sub