Issue with Incorrect VBA Syntax in Microsoft Excel Documentation

Question

Dear Microsoft Support,

I would like to bring to your attention an issue I encountered in the VBA documentation and related online resources. It appears that there is a discrepancy regarding the usage of the "Target" variable in the Worksheet_SelectionChange event.

In multiple instances, the variable is incorrectly written as "Targed", which causes confusion and errors when implementing VBA code. The correct syntax should be "Target", with a lowercase "t" at the end, as it is the standard variable name for referring to the selected cell or range.

This inconsistency may lead to unnecessary troubleshooting, as users may unknowingly use the incorrect spelling "Targed", causing errors in their code.

I am using the English version of Microsoft Office, and this issue has affected my work. I kindly request that this be addressed and corrected in future documentation updates to ensure clarity and accuracy for Excel users, especially those using localized versions of Office.

 Kind regards,
Dainis

p.s. Book1.xlsm

I created a new document and added the macro to it. If anyone has big eggs, they can save and boil them. :)

Answer 1

I tried it on my home computer and added a screenshot. Check the system settings and Office version. Everything is ok on my home computer.

p.s. And now you're telling me my hands are growing out of place!

![Image](https://learn-attachment.microsoft.com/api/attachments/5390150b-d606-427f-90d6-54f80f46b6ad?platform=QnA"https://learn-attachment.microsoft.com/api/attachments/c5fbde11-5f47-419b-bbfd-06abcdcfaf9f?platform=QnA" title="filestore.community.support.microsoft.com" rel="ugc nofollow">

I've been working in the IT field for over 35 years, I'm a little older than you :)

Answer 2

And what does all this have to do with your question? Nothing.

I don't think I can help you any further; I've already said everything that needs to be said.

Andreas.

Answer 3

I have no problem. But this problem is in a specific version of office. You could also look at this problem with big eyes and not solve it. Therefore, I shared such a problem and so that others whose native language is not English would have such a problem described somewhere. p.s. a suggestion for you, if you don't have a solution, then don't start teaching others to pee against the wind! respect others and they will respect you. Peace in your homes.