CODEWITHSUNDEEP
excelvbavariablescapitalization
Name
Name

Reputation: 209

Why do some words in VBA automatically have a lowercase first letter?

Has anyone seen the phenomenon where certain words, not keywords, but just certain variable names will automatically change the first letter to lower case. It's quite annoying, for example, I have a variable I tried to name "SiteNumber" and everytime it switches across the whole module to "siteNumber", I have tried a Replace All and still nothing works. The same thing happens when I try to name a variable "CarrierName", everytime it changes automatically to "carrierName". Any insight?

Upvotes: 0

Views: 1328

Answers (1)

ahmed.essam
ahmed.essam

Reputation: 1

I think you can try writing

Dim SiteNumber, CarrierName

only it should work alone and change the Var names in whole code but sense you said that you used replace all tool, i am not certain if its going to work or not, but it is worth to give it a try.

Upvotes: 0

Related Questions