FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Update only the selected data Press ALT+F5, or on the Data tab, in the Connections group, click the arrow under Refresh All, and then click Refresh. Update all data in the workbook Press CTRL+ALT+F5, or on the Data tab, in the Connections group, click Refresh All.

Detailed explanation-2: -Using an Input Box Let’s say you want to enter the value in cell A1, the code would be like this: Range("A1"). Value = InputBox(Prompt:="Type the value you want enter in A1.") In the above code, the value from cell A1 assigns to the value returned by the input box that returns the value entered by the user.