VBA Invalid Qualifier on Strings

[amzngspiderman29]

I'm working on a simple Macro for Excel, but I'm new to Visual Basic and I'm encountering some errors when working with strings. Here's an example of the error I keep running into:

Sub test()

Dim s1 As String
Dim s2 As String
s1 = "which case"
s2 = s1.ToUpper

End Sub

When I try to run this, I keep getting the error "Invalid Qualifier" highlighting s1.ToUpper

Thanks for any help!

[MartinLiss]

So are you doing this coding within Excel? If so let me know because you may have posted in the wrong forum.

[amzngspiderman29]

I went in through Excel and am using the Visual Basic Editor under Macros. I then added a new module in the VB Editor which is where my code is located.

[MartinLiss]

I'll assume that's a "yes" so I moved the thread to here.

[anhn]

I'm working on a simple Macro for Excel, but I'm new to Visual Basic and I'm encountering some errors when working with strings. Here's an example of the error I keep running into:

Sub test()

Dim s1 As String
Dim s2 As String
s1 = "which case"
s2 = s1.ToUpper

End Sub

When I try to run this, I keep getting the error "Invalid Qualifier" highlighting s1.ToUpper

Thanks for any help!

The code you wrote is for VB.NET? That does not work in VB6 or VBA.
Change it to:

Sub test()
   Dim s1 As String
   Dim s2 As String

   s1 = "which case"
   s2 = UCase(s1)

End Sub

[salvelinus]

However,if you write it in a formula in a cell, you would use Upper(A1), at least through XL 2K. And if you were writing VBA (macro) code, that is what you'd need.
Not sure if you're running XL as an application from another program.
No idea why the same versions of office would use UCase for some apps and Upper for others.

[anhn]

However,if you write it in a formula in a cell, you would use Upper(A1), at least through XL 2K. And if you were writing VBA (macro) code, that is what you'd need.
Not sure if you're running XL as an application from another program.
No idea why the same versions of office would use UCase for some apps and Upper for others.

The Sub Test() code is VB6/VBA code.
UCase() and LCase() are 2 of basic functions in VB6/VBA, they works wherever these languages are used.

UPPER() and LOWER() are 2 WorksheetFunctions that can be used on worksheet within formulas only.

The reason why VB uses UCase() and LCase() but worksheetfunction uses UPPER() and LOWER() is at the creation of Excel, MS intended to make the functions compatible with Lotus 1-2-3 functions.

[nightsiayer]

SMonth = CBSMonth.ListIndex + 1
SYear = CBSYear.ListIndex + 1

when i try to run the program, they gave me the invalid qualifier msg box and highlights CBSMonth

can any1 help me please?

[MartinLiss]

Nightslayer, check the dates on threads; this one is 4 years old.

[Spoo]

Nightsiayer

Welcome to the Forums ..

It appears that you dilligently did a Search Forums on
Invalid Qualifier, and thus found this thread, but, as
Marty points out, this thread is ancient.

So, it might be appropriate to start a new thread.
Further, it would help if you would give a little more
code.

EDIT

BTW, I'm amazed at the number of Views of this thread ... 3,348 ..
and only 9 replies.

Spoo