Forum Discussion
Jeff43615
Dec 06, 2022Copper Contributor
Excel vba declared a variable using object
I stupidly decided to name a shape variable as so: Dim shaPes as Shape I have since removed the variable and all usage of it from the entire project. Even though I have, every time I want use...
- Dec 12, 2022Thank you for your answer. Unfortunately, I was not able to resolve the error using this method. After digging much deeper in Stack Overflow I was able to find a solution.
https://stackoverflow.com/questions/38640121/vba-object-properties-appear-in-lower-case
Of course I will be avoiding this in the future by staying away from reserved words.
SnowMan55
Dec 10, 2022Bronze Contributor
Jeff43615 Did this behavior still occur after you removed the variable, closed Excel, and reopened the workbook? If so, my suggestion is to use the VBE Tools | References dialog to note the relative location of "Microsoft Excel nn Objects Library", then (temporarily) place that reference at the top in priority. Save, close, reopen, and check again.
- Jeff43615Dec 12, 2022Copper ContributorThank you for your answer. Unfortunately, I was not able to resolve the error using this method. After digging much deeper in Stack Overflow I was able to find a solution.
https://stackoverflow.com/questions/38640121/vba-object-properties-appear-in-lower-case
Of course I will be avoiding this in the future by staying away from reserved words.- SnowMan55Dec 12, 2022Bronze ContributorGlad you found a solution, and thank you for posting the Stack Overflow link.