I am a newbie with VBA here and only started a few days ago. I am trying to recreate a version of customer manager app from Excel For Freelancers
I was able to get the Macro run and load the data. However, when I try to code in the run macro when Sheet 1 change, I received an error message "Method 'Value' of object 'Range' failed". Could our experts here let me know where I went wrong? I attached a sample workbook as well. Thank you in advance for everyone's help!
Below is the module I was able to run manual until the worksheet change