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.
Jeff43615
Dec 12, 2022Copper Contributor
Thank 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.
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 12, 2022Bronze Contributor
Glad you found a solution, and thank you for posting the Stack Overflow link.