Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Upper Case 3

Status
Not open for further replies.
JohnAcc

JohnAcc

Technical User
Aug 13, 2003
143
GB
Hi all,

I can't work out how to change a string variable to uppercase. I know excel has an upper function but vba does not appear to haev one.

I have tried the following to no avail:

NewString = Upper(Stringvariable)

Any ideas ?

Rgds, John

 
Sort by date Sort by votes
Yes it does, try
NewString = UCASE(Stringvariable)
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

davefish
  • Locked
  • Question
Dynamic part number creation...Should I use Select case, if statement or combination
Replies
15
Views
384
davefish
davefish
UnsolvedCoding
  • Locked
  • Question
Select Case 1
Replies
11
Views
220
mintjulep
M
PWD
  • Locked
  • Question
Sorting Items in a ListBox appears to sort Proper Case words then lower case words 1
Replies
2
Views
125
PWD
PWD
Evil8
  • Locked
  • Question
Setting a column to a Named Range to Changing the data with Case 1
Replies
9
Views
231
Evil8
Evil8
MottoK
  • Locked
  • Question
VBA code to change last letter of string to uppercase on one column 1
2
Replies
25
Views
843
MottoK
MottoK

Part and Inventory Search

Sponsor

Back
Top