ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Case query (https://www.excelbanter.com/excel-programming/413410-case-query.html)

Greg B[_3_]

Case query
 
Hi all,

I want to have a password but i need the word not to be case sensitive. How
do I achieve this?

Thanks
Greg B



Rick Rothstein \(MVP - VB\)[_2218_]

Case query
 
Store your (encrypted, hopefully) passwords in lower case, use the LCase
function on the inputted password and compare it to the stored lower case
passwords.

Rick


"Greg B" <littlelap(no wrote in message
...
Hi all,

I want to have a password but i need the word not to be case sensitive.
How do I achieve this?

Thanks
Greg B



Greg B[_3_]

Case query
 
thankyou I didnt think of the easy way to do it.Just making it too
complicated for myself. Thanks for the advice

Greg
"Rick Rothstein (MVP - VB)" wrote in
message ...
Store your (encrypted, hopefully) passwords in lower case, use the LCase
function on the inputted password and compare it to the stored lower case
passwords.

Rick


"Greg B" <littlelap(no wrote in message
...
Hi all,

I want to have a password but i need the word not to be case sensitive.
How do I achieve this?

Thanks
Greg B






All times are GMT +1. The time now is 05:05 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com