Posted to microsoft.public.excel.programming

Calle

external usenet poster

Posts: 70

Can I get VBA script to read a word with both lcase and ucase lett

Hi!
I am using this script but it can only read text with small letters. Can I
change it to read with both small and big letters:

Case Is = "i13"
If LCase(.Value) = LCase("select door") Then
'skipit
End If

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Anyone know of a way, or have a script, to read a TOC from CD's?	Bob Parker	Excel Programming	1	June 25th 05 09:48 PM
Read only password script box	Joey041	Excel Discussion (Misc queries)	1	May 3rd 05 01:23 AM
Get…UCase or LCase ???	Totmos	Excel Programming	0	January 8th 04 07:09 PM
Get…UCase or LCase ???	Totmos	Excel Programming	2	January 8th 04 06:15 PM

All times are GMT +1. The time now is 11:10 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us