Attribute Issues

[Pestomania]

Hi! Whenever I dim an attribute to "shape" it makes it captialize weird. Say I type "dim shp as shape" it returns this "Dim shp as sHape"

Anyone know why it would capitalize the "H"?

 

[Fluff]

It sound like at some point you have used sHape as a variable, or the name of a procedure.

 

[shg]

Add this line to any module and then delete it:

Dim Shape

 

[shg]

To amplify: In VBA, the last declaration of a variable sets the capitalization for all variables, procedures, objects, properties, methods, and enumerations of the same name project-wide. “Last declaration” includes declarations in the signature of procedures, e.g.,

Function myFunc(bob As String) As Variant

As a result, it’s impossible to have in the same project a variable, object, property, method, or enumeration named Bob and another named bob.

So if you see

ActiveWorkbook.name

just enter and delete one line anywhere in the project:

Dim Name

It will change the case of all appearances of the word project-wide.

 

[Pestomania]

Perfect!! Thank you!!

 

[shg]

You're welcome.