I am using MsgBox to ask the user if data input that links to a chart must be cleared. If the user selects "Yes", data is cleared but the chart displays as if the data was not deleted. The chart only updates once all the input has been entered. How can I update the chart as soon as the user selects "Yes" ?
Thanks in advance![]()
Answer = MsgBox(Prompt:="Clear previous input", Buttons:=vbYesNo + vbQuestion, Title:="Warehouse Input") If Answer = vbYes Then Range("WarehouseInput").ClearContents End If
Bookmarks