syntax for to upper case letters?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi I have a form coded involving the characters "P" and "Q". But I need
the form to still run without any runtime errors even though the user
enters a lower case p or q. Whats the syntax for the to upper case
letters. Here is my code. Keep in mind that this code works, I just
need to add the to upper statement.

r = Application.CountA(Range("A:A"))

If Left(parttxt.Text, 1) = "P" And Left(qtytxt.Text, 1) = "Q" Then
Range("A1").Offset(r + 1, 0) = Me.parttxt.Value
Range("B1").Offset(r + 1, 0) = Me.qtytxt.Value
Me.parttxt.Value = ""
Me.qtytxt.Value = ""
Me.parttxt.SetFocus
Else: MsgBox "Wrong Part or Qty Scanned", vbCritical
Me.parttxt.Value = ""
Me.qtytxt.Value = ""
Me.parttxt.SetFocus


End If
End Sub

.

Relevant Pages

  • Re: Some interesting facts
    ... Upper and lower case letters are named 'upper' and 'lower' because ... Well I won't be writing any poems tonight. ... of celery than the celery has in it to begin with. ...
    (alt.vacation.las-vegas)
  • Some interesting facts
    ... Money isn't made out of paper, ... Upper and lower case letters are named 'upper' and 'lower' because ... of celery than the celery has in it to begin with. ...
    (alt.vacation.las-vegas)
  • Re: letter number count
    ... D1:D26 - key in upper case alphabet - a through z ... First calculation you gave me was for figuring occurences of A-Z and 0-9 ... Valko" wrote: ... also wanted to add lowercase letters (just three lowercase letters a,e, & ...
    (microsoft.public.excel.worksheet.functions)
  • Re: letter number count
    ... Thanks for the upper and lower case explanation, ... First calculation you gave me was for figuring occurences of A-Z and 0-9 ... Valko" wrote: ... also wanted to add lowercase letters (just three lowercase letters a,e, & ...
    (microsoft.public.excel.worksheet.functions)
  • Re: The case for lower case
    ... both pure lower and upper case tend to slow down ... > Lower case letters contain more visual "information" than upper case ... > and cover up the top half of a row of all upper case characters. ... black background more pleasing than other combinations. ...
    (alt.lang.asm)