[BUG]cell comment(cell note?) writes to wrong cell address
- download attached txt file, change its extension to xlsm
- open it, select from line 9 to line 110, copy them, select line 125, paste, press Esc to exit the copy paste status, scroll up the page to the top(first row)
- Mouseover to I1, G3 and D8, view their cell note, they're "0 records imported successfully", a very long string starting with "SSC -: SSC return <some other contents>", and "Shynetta <some other contents>"
- click "Button 20" to execute the macro, bug occurs
Expect: I1's cell note should be "0 records imported successfully", G3's cell note should be a very long string starting with "SSC -: SSC return <some other contents>", D8's cell note doesn't change
Actual: I1 and G3's cell note are both empty, D8's cell note is changed from "Shynetta <some other contents>" to a very long string starting with "SSC -: SSC return <some other contents>"
Check the "Button 20"'s macro code, it reads I4's value and set it to G3's cell note(in code it's cell comment), so the expect result is G3's cell note(rather than D8's) is I4's value(a very long string)
The copy-paste in step 2 is important, if skipping the copy paste, the bug cannot be reproduced
Actually I made a screen recording to reproduce the bug, but the attachment doesn't support .mp4 and the size has 3MB limit so I cannot upload it.
System: Windows 11
Excel Version: Microsoft 365 Apps for enterprise, Version 2405 (Build 17628.20188 Click-to-Run)