* Determine Capitalization

		Microsoft Office Forums > Microsoft Excel > Excel
* Determine Capitalization

FAQ

Thread Tools

Display Modes

05-02-2011, 01:48 PM

macropod

Windows 7 32bit * Determine Capitalization

Office 2000

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Hi Rey,

When doing the VBA comparison, wrap both expressions in the UCase function. This will force the comparison to be done on the basis of the capitalized versions of the strings.

Code:

Sub Demo()
With ActiveSheet
  If UCase(.Range("A1").Value) = UCase(.Range("B1").Value) Then
    MsgBox "!"
  End If
End With
End Sub

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Last edited by macropod; 05-03-2011 at 01:23 AM.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to determine a user's mailbox size limit?	enviroko	Outlook	3	05-13-2010 07:02 AM
Macro to determine attached template	zippyaus	Word VBA	0	03-02-2010 02:05 AM
Anyway to determine time/date of text creation?	pureride	Word	1	01-05-2010 02:09 PM
Determine age by using birthdate	gdodson	Excel	1	08-11-2006 09:27 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:43 AM.