Be the first user to complete this post
|
Add to List |
VBA-Excel : Strings Functions – Ucase
Description:
This function converts the input string to Upper case.
Format:
UCase(strString)
Arguments:
- strString
- Mandatory
- Type: String
- String whose characters to be converted in Upper case.
Function FnUpperCase() Dim mainString mainString = "SumitJain" MsgBox UCase(mainString) End Function
![UCase](/static/media/excel/2013/05/ucase.jpg)
Also Read About Other String() Functions
INSTR() | InstrREV() | LCase()
Also Read:
- VBA-Excel: Date-Time Functions – Date(), Now() and Time()
- VBA-Excel: String Functions – String()
- VBA-Excel: Date-Time Functions – Month(), Year() and MonthName()
- VBA-Excel : 3D-Ranges - Working with Multiple WorkSheets At The Simultaneously
- Excel-VBA : Range - Lock/Unlock Specific Cells