Question

excel如何设置单元格输入内容后自动显示输入内容并要求确定一遍

不希望用另一个单元格重复相同内容来校正，希望是弹出对话框，点击确定。谢谢高手解答

Answer 1

请输入完毕后按回车键，代码生效
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Selection.Value = "" And Selection.Offset(-1, 0) = "" Then Exit Sub
MsgBox "您刚输入的值为：" & Selection.Offset(-1, 0).Value & "请确认输入是否正确", vbInformation, "提示"
End Sub

Answer 2

这个要用vba才行