VBA TO CONVERT TEXT TO UPPERCASE

[egris52788]

i need a macro that will change an entire sheet to uppercase. we are not allowed to download utilities, therefore I cant use asap utilities, i need to put the code directly into my workbook. thanks

 

[Peter_SSs]

I don't follow the Sub DriverName_Change()
It
- Declares DriveName as String,
- Doesn't assign any value to that variable (so it will be an empty string)
- Converts to upper case (but there was nothing to convert)
- Tries to Return somewhere (but where?)

However, in the main procedure, assuming that it works (that is, does not error) are you saying that making the following change causes that error to occur?

Do
DriverName = InputBox("What is the name of the Driver you are adding?")

<del>DriverName = Application.WorksheetFunction.Proper(DriverName)</del>
DriverName = UCase(DriverName)

AddDriverStart:

 

[b9k9uk]

Sorry for the confusion! The line DriverName = Application.WorksheetFunction.Proper(DriverName) was substituted with Call but I took it out when it didn't work and reverted to the 'Proper' line.

Unfortunately DriverName=UCase(DriverName) does not work returning the error Can't find project or library.

 

[Peter_SSs]

See if this helps: UCase problem - Microsoft Community

 

[b9k9uk]

That did it! Many thanks Peter

The line should read DriverName = VBA.Ucase(DriverName)

Hope this helps others.

Again many thanks for your help.