Hi, Can anyone help to my VBA issue. I want cell A3 get value from cell A1 automatically whenever I select sheet1 without clicking run button. Thanks, Chanthan