PDA

View Full Version : Solved: vb "Upper"



Emoncada
02-24-2010, 09:48 AM
I have the following.


.formFields("SVNAME011").result = Left(ws.Range("K3").Value, 5)

I would like to make the value as an "UPPER"

Something like this


.formFields("SVNAME011").result = Upper(Left(ws.Range("K3").Value, 5))

But that isn't working.
What am I doing wrong?

GTO
02-24-2010, 10:35 AM
Try:.formFields("SVNAME011").result = UCase(Left(ws.Range("K3").Value, 5))

Hope that helps,

Mark

Emoncada
02-24-2010, 10:36 AM
lol I just figured it out as you posted. Thanks GTO