Name

UCase Function

Syntax

UCase(string)
string

Use: Required

Data Type: String

A valid string expression.

Return Value

A String.

Description

Converts a string to uppercase.

Rules at a Glance

  • UCase affects only lowercase alphabetical letters; all other characters within string remain unaffected.

  • UCase returns Null if string contains a Null.

VBA/VBScript Differences

VBA includes a UCase$ function that returns an uppercase string rather than a uppercase string variant. Because VBScript does not support strong typing, the function is not implemented in VBScript.

Get VBScript in a Nutshell, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.