Transforming Uppercase to Lowercase

[daniel chen]

Cells(1, 1) = "ABC" 'as given
Cells(1, 2) = Cells(1, 1) 'but I want it in lower case i.e. "abc"
Will someone help me with the VBA codes, please?

 

[Katie]

Hi there,

Adjust your second line of code so that it reads:

Cells(1,2) = LCase(Cells(1,1)) 'this will convert Cells(1,1) to lowercase.

LCase is a built in function.
UCase does the reverse, (ie) will convert a string to uppercase.

Hope this helps
Katie

 

[Jim May]

Cells(1, 1).Value = "ABC"
Cells(1, 2).Value = LCase(Cells(1, 1))

 

[daniel chen]

Thank you very much, Jim

Cells(1, 1).Value = "ABC"
Cells(1, 2).Value = LCase(Cells(1, 1))

 

[daniel chen]

Thank you, Katie

Hi there,

Adjust your second line of code so that it reads:

Cells(1,2) = LCase(Cells(1,1)) 'this will convert Cells(1,1) to lowercase.

LCase is a built in function.
UCase does the reverse, (ie) will convert a string to uppercase.

Hope this helps
Katie